Excel Jululian

G

George A. Jululian

Hi all,

I have table from Row 3 till Row 7000 and I have a formula
(=LARGE(D3:D7000,C7050)) at the end to find me the first 10 large numbers in
the table
I need formula to find for me the result of the formula came from which row
number

A B C
Days in Stock Arrival date Prod. Month

3 220 11/05/2008 01/02/2008
4 269 23/03/2008 01/02/2008
5 360 23/12/2007 01/04/2008
6 475 30/08/2007 01/04/2008
7 526 10/07/2007 01/05/2008
8 609 18/04/2007 01/04/2008


11 1 609
12 2 526
13 3 475
14 4 360
15 5 269
16 6 220
 
B

Bernie Deitrick

This will return the row number

=MATCH(LARGE(D3:D7000,C7050),D:D,False)

HTH,
Bernie
MS Excel MVP
 
G

George A. Jululian

Many thanks it was very helpful

but why we should put false and not zero

Regards
 
B

Bernie Deitrick

False forces an exact match - and is more in line with Excel's Help explanation of the MATCH
function, so it is easier to read and understand than using numbers for True or False.

HTH,
Bernie
MS Excel MVP
 
B

Bernie Deitrick

I'm sorry - I was confusing the help for MATCH with the help for VLOOKUP - so I guess my answer
really is that using False is a habit I got into to force exact matches in the match and lookup
functions...

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top