Sort data with same value

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

QUESTION ONE
I have alot of data that needs to be sorted by date column A and and column E and F have values entered. Now need to sort only data that has similar amounts of column E and F is there a way

QUESTION TWO
In column E and F on each row need the value of column F that is less than value of column E for the font to be in colour Red. then need to copy formular downwards.

Thanks

LilBee


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you post a sample excel workbook with some data in it. Please have two sheets in it, one the raw data as it is now. in the other sheet, how you want data to look like. Please post that sample book at some public file share site and post the link to the FILE back here