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.

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.