I have to use Excel all the time but have never taken the trouble to learn it in any depth, so wondering if someone can tell me how to do the following:
I have a long list of values in say column A and corresponding values in column B (eg names of clients in A and their outstanding fees in B). If I wanted to 'sort' column A eg by alphabetical order, how would I do it so the corresponding B values stay next to them?
Cheers
I have a long list of values in say column A and corresponding values in column B (eg names of clients in A and their outstanding fees in B). If I wanted to 'sort' column A eg by alphabetical order, how would I do it so the corresponding B values stay next to them?
Cheers
