Thread: Excel Jululian
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George A. Jululian[_2_] George A. Jululian[_2_] is offline
external usenet poster
 
Posts: 89
Default 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