F
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
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