Forum Discussion
Best way to sort data if the data/cells in one column depend on the data/cells in another column?
Normally I'd make a formula, but I need to arrange the rows where the data in both colums are either the same or more. Not sure how to sort this. Please advise
Hi Yasmin,
Just use the Sort feature in Excel.
but, before use it, make sure that your columns are adjacent.
If you want to learn more about the Sort Feature, just follow this link:
http://bit.ly/2lSfqp3
- Thanks Haytham but I need to arrange the rows so that if the data in Col B and D match they go to the top and if greater than D-B they go to the bottom. Can't see an option in sort, unless I change their colour.
Hi,
In column C write this logical formula:
=A2=B2
and then copy it down.
It's will give you TRUE, if the A2=B2, and FALSE if it not.
When you finish, you can now sort the TRUE/FALSE column from Z to A to get what you want.
