how to chek greater then equal numbers
 

Dear All
i'm having data's(numbers) in 6 column i want to know what is the greater
number and i'll give some example:-
A B C D E F G H I
are all Columns.
10 10 3 900 870 14.5 20 28 AA3A
50 55 5 1260 4260 28 30 10 AA2B
85 5 5 2160 3088 85 45 10 AA3C

48 48 10 6177 2287 86 10 20 AA5E
Here in above example D is greater than r equal to E then it has to check
ABC and again it has to check what is the greater than r equal to number in
Columns result is like to be(i'll take 1 row for example)( if it is D is
900it has to check in E column where and what is the greater number for 900
then it has to check ABC columns and again it has to chek the FGH then the I
columns data has to come) like 900 what is the greater number for 900 in E
Column 2287 is the next greater number FGH column greater number are there
then the I column data is AA5E )

for this what is the formula i have to use can use. if u give me this
formula to solve this problem.i'm always very greatfull to u......
I'M using Excel Version 2003.
but pls provide the result.

how to chek greater then equal numbers
 

Please re-state the question. It seems you need something like
=IF(D1=E1,"ABC","XYZ")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Jai" wrote in message
...
Dear All
i'm having data's(numbers) in 6 column i want to know what is the
greater
number and i'll give some example:-
A B C D E F G H I
are all Columns.
10 10 3 900 870 14.5 20 28 AA3A
50 55 5 1260 4260 28 30 10 AA2B
85 5 5 2160 3088 85 45 10 AA3C

48 48 10 6177 2287 86 10 20 AA5E
Here in above example D is greater than r equal to E then it has to check
ABC and again it has to check what is the greater than r equal to number
in
Columns result is like to be(i'll take 1 row for example)( if it is D is
900it has to check in E column where and what is the greater number for
900
then it has to check ABC columns and again it has to chek the FGH then the
I
columns data has to come) like 900 what is the greater number for 900 in
E
Column 2287 is the next greater number FGH column greater number are there
then the I column data is AA5E )

for this what is the formula i have to use can use. if u give me this
formula to solve this problem.i'm always very greatfull to u......
I'M using Excel Version 2003.
but pls provide the result.