Hello there... I am VERY new to Excel 2007 and need help with the following;
I have 3 columns of Data.. A, B, C. Columns B and C are related in that column B has numbers and Column C is a description of those numbers (client information, every number in A and B is a client.)
Column A has numbered clients from 24-9000 with about 1200 missing numbers in that range (a shortlist of clients, thus the missing #'s)
Column B has numbered clients from 11-13500 with NO missing numbers (older Main/Master list of clients).
I want to line up both column A and B so that any LIKE numbers line up from top to bottom, keeping in mind that Column C is Text that corresponds to Column B and must 'line-up' with Column B numbers once 'sorted'.
Any 'excess' numbers and text from Columns B and C that are NOT FOUND in Column A are of no consequence and will be deleted.
Thanks for any help you can provide!
Cheers,![]()
Bookmarks