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" <(E-Mail Removed)>
wrote in message
news:efxYq.446$(E-Mail Removed)...
> Please provide formula
>
> Thanks
>
>
> "Jim Cone" <(E-Mail Removed)> wrote in message news:jgu1l9$pp7$(E-Mail Removed)...
>> Yes
>>
>>
>>
>>
>> "Fawn Lagimodiere" <(E-Mail Removed)>
>> wrote in message
>> news:LTjYq.10639$(E-Mail Removed)...
>>>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
>>
>>
>
>
