Hi, so I have 3 columns, a team name and then 2 columns of numbers which are formulas, I want to sort these 3 columns into alphabetical order but when I click sort now it does not move the other 2 columns of numbers with it. Thanks
Capture.JPG
Hi, so I have 3 columns, a team name and then 2 columns of numbers which are formulas, I want to sort these 3 columns into alphabetical order but when I click sort now it does not move the other 2 columns of numbers with it. Thanks
Capture.JPG
You should probably sort cells with data rather than cells with formulas
What are the formulas in the two columns ?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi saintc and welcome to the forum,
Be sure you select all three columns before you press Sort. Here is a full document to help with your problem.
https://www.ucc.ie/en/media/support/...dFiltering.pdf
You might also need to insure you have a header row on each column to do what you want.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi, yes I have sorted it thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks