 Ask Remember Me? vks64 Posts: 53, Reputation: 1 Junior Member #1 May 18, 2011, 07:39 PM
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
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 JBeaucaire Posts: 5,426, Reputation: 997 Software Expert #2 May 19, 2011, 03:35 PM
Try these formulas...

E2: =AND(\$A2<\$B2, \$B2<\$C2, \$C2<\$D2)
F2: =AND(\$A2>=\$B2, \$B2<\$C2, \$C2<\$D2)
G2: =AND(\$A2>=\$B2, \$B2>=\$C2, \$C2<\$D2)
H2: =AND(\$A2>=\$B2, \$B2>=\$C2, \$C2>=\$D2) vks64 Posts: 53, Reputation: 1 Junior Member #3 May 22, 2011, 09:46 AM
Comment on JBeaucaire's post
Thank You

 Question Tools Search this Question Show Printable Version Email this Page Search this Question: Advanced Search

## Check out some similar questions!

Sir I have a set of data in excel sheet A as below: Sheet A Name of the students Marks in english Marks in maths A 45 74 B 38 58 C 52 65 D 45 65 E 88 72 F 36 45