Sort data with same value

Closed
LilBee - Nov 28, 2011 at 06:32 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 30, 2011 at 04:53 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 30, 2011 at 04:53 PM
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
0