#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 89
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"