sorting / formula

C

clueless

I need a formula that will sort/rearrange names to match another column. for
example Column A has 50 names (sorted aphabetically) and Column B has 30
names (sorted aphabetically). Is there any formula that i can put in column
C which will make the names in column b sort to match the names in column A?
Essentially some rows in column c will be blank as there are 20 names missing.

Any help is highly appreciated.
 
P

paul.robinson

Hi
In excel look up the help on "sort a range". look at sub heading "use
your own data as the sort order".
regards
Paul
 

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

Similar Threads

Need help with a Formula 1
Sorting Columns with a Formula 1
Help with sorting data 3
Copying a formula to a range 2
Find and match text and return column and row reference 0
Excel 2 into 1 6
Match file names listed in column with file names in folder 1
Sorting Data 8

Top