Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|