copy and pasting in 5000 records referencing cells

[Fawn Lagimodiere]

I have a file that is 5000 records long.

example

Column A Column B
namea
nameb
namec
Transit number associated with (a,b,c)

What I want is to have transit number appear in Column a beside each of the
individuals.

The issue is the transit number is different for all 5000 records some may
have 5 per transit number and others just 3 and some have 7 depending on
size of the branch.

Is there a formula to populate this without copy and pasting in each cell?

thanks

 

[Jim Cone]

Yes




"Fawn Lagimodiere" <[email protected]>
wrote in message
news:[email protected]...

 

[Fawn Lagimodiere]

Please provide formula

Thanks

Yes




"Fawn Lagimodiere" <[email protected]>
wrote in message

 

[Jim Cone]

Assumes data starts in B3; enter formula in A3; fill down...
=IF(ISNUMBER(B3),B3,IF(ISBLANK(B3),"",A4))
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Color/Delete/Insert rows; Date picker/Insert random stuff)




"Fawn Lagimodiere" <[email protected]>
wrote in message