Excel 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

Excel Jululian
 

This will return the row number

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

HTH,
Bernie
MS Excel MVP


"George A. Jululian" wrote in message
...
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

Excel Jululian
 

Many thanks it was very helpful

but why we should put false and not zero

Regards

"George A. Jululian" wrote:

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

Excel Jululian
 

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


"George A. Jululian" wrote in message
...
Many thanks it was very helpful

but why we should put false and not zero

Regards

"George A. Jululian" wrote:

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

Excel Jululian
 

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


"George A. Jululian" wrote in message
...
Many thanks it was very helpful

but why we should put false and not zero

Regards

"George A. Jululian" wrote:

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

Excel Jululian
 

Many Thanks it was clear

"George A. Jululian" wrote:

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