List count changes and large function will not work

[Edmonch1]

I use the large function to rank values in descending order however when the number in the list changes (say from 40 down to 20) the large function will not work unless i modify the formula. Is there a better way?

 

[Muhammad_Usman]

Share your data for more clarification!

 

[Edmonch1]

Device	Category	Type	Time		Type "=LOOKUP(2,1/(COUNTIF($O$1:O1,$C$2:$C$46)=0),$C$2:$C$46)"	TIME TOTAL - "=SUM(IF(C$2:C$46=O2,D$2:D$46,0))	LARGE FORMULA "=LARGE($P$2:$P$46,N2)	Type Index - '=INDEX(O:O,MATCH(Q2,P:P,0))
1	Duration	Sample 45	185.5	1	Sample 3	7.639106737	#N/A	#N/A
1	Duration	Sample 45	156.1	2	Sample 22	20.1890678	#N/A	#N/A
1	Duration	Sample 45	155.5	3	Sample 4	43.10638802	#N/A	#N/A
1	Duration	Sample 45	109.7	4	Sample 2	74.20846544	#N/A	#N/A
1	Duration	Sample 45	102.6	5	Sample 1	429.4269287	#N/A	#N/A
1	Duration	Sample 45	99.3	6	Sample 45	1380.495717	#N/A	#N/A
1	Duration	Sample 45	97.7	7	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 45	78.6	8	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 45	73.7	9	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 45	54.0	10	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 45	48.6	11	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 45	48.0	12	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 45	43.7	13	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 45	43.7	14	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 45	42.6	15	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 45	41.5	16	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 1	38.7	17	#N/A	#N/A	#N/A	#N/A
1	Duration	Sample 1	37.1	18	#N/A	#N/A	#N/A	#N/A

<tbody>
</tbody><colgroup><col span="3"><col><col><col><col><col><col></colgroup>

 

[Edmonch1]

I tried to send the data in this window..I cannot seem to find where to attach the file

 

[Muhammad_Usman]

What is value in "O" Column ??

 

[Aladin Akyurek]

@Edmonch1

Care to post sample data along with the desired output? (An output specified by means of non-working formulas is not helpful.)

 

[Edmonch1]

O column will give the unique list. I used the formula "=LOOKUP(2,1/(COUNTIF($O$1:O1,$C$2:$C$46)=0),$C$2:$C$46)" I need the Large formula to change because the number of entries will change. Large formula is "=LARGE($P$2:$P$46,N2)" I have to manually change the Large formula to the specific number in P column then it works. I wish I could attach the file

 

[Edmonch1]

I cant post..Is there a trick I'm missing

 

[Edmonch1]

large formula.xlsm :: Free File Hosting - File Dropper: File Host for Mp3, Videos, Music, Documents.

 

[Aladin Akyurek]

I cant post..Is there a trick I'm missing

In post #3 you did, but the sample provided doesn't seem to be adequate. By the way, for possible methods for posting useable samples, see Attachments.