I have large numerical data stored in excel sheet. I wanted to write simple formulas to compare the numerical values in the columns A to Z.
For Example to compare the values in columns A,B,C,D of the sheet(values of A,B,C,D arranged chronologically). I wanted formulas in the newly inserted columns E,F G H like this:
col ‘E’ as If A<B<C<D = Result as True and for otherwise, result as false
col ‘F’ as If A not less than B but<C<D =Result as True and for otherwise, result as false
col ‘G’ as If A not less than B not less than C but <D = Result as True and for otherwise, result as false
col ‘H’ as If A not less than B not less than C not less than D=Result as True and for otherwise, result as false
In continuation of the above please reply,
1) whether it is possible to color the cells based on the formula results for true and false?
2) whether it is possible to sort out the cells based on the cell colors?
Thank you
vks64