copy and pasting in 5000 records referencing cells

  • Thread starter Fawn Lagimodiere
  • Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top