What formula i can use to get the result

Closed
jaikrish_18 Posts 11 Registration date Monday February 23, 2009 Status Member Last seen April 15, 2009 - Mar 22, 2009 at 08:06 AM
jaikrish_18 Posts 11 Registration date Monday February 23, 2009 Status Member Last seen April 15, 2009 - Mar 31, 2009 at 07:31 AM
Hello,
in Excel I'm having Length WidthHight datain 3 coloums
for example
Column A---Column B---Column C
Length Width Height
10 20 10
20 30 10
Column E---Column F---Column G
Length Width Height
10 15 10
25 30 15
The same typ of data in Column D,E,F
Like this around 1000 rows datas r there.
how to match length Width Height data together(how to match 3 column and find the exact match from DEF r next Higher from DEF) Higer data means 10,20,10 next higers is greather than these 3 column(25,30,15).
what formula i can use to get the result

1 response

Dette04 Posts 10 Registration date Monday January 19, 2009 Status Member Last seen May 2, 2009
Mar 23, 2009 at 03:47 AM
jaikrish_18 Posts 11 Registration date Monday February 23, 2009 Status Member Last seen April 15, 2009
Mar 31, 2009 at 07:31 AM
pls send tha formula ineed the formula i checked that book no formula is available