Top 5 Denomination

[vishan]

Hi,

i have some data where i want top 5 denomination of 1 customer no. there is huge data with customer no. & it's denomination.

Data is like below.

Customer no. Denomination
[TABLE="width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]8130038377[/TD]
[TD="align: right"]130[/TD]
[/TR]
[TR]
[TD="align: right"]8130038377[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]8130038377[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130039898[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]


Pls help in this

rgds
Vishan

 

[Armando Montes]

This can help:
Excel: Finding the nth Value That Meets a Condition

 

[Akashwani]

Hi Vishan.

Does this work for you?
It will show duplicate values, I'm unsure as to the method to avoid this, but Mike may have the answer here...
excelisfun -- 1900 Excel How To Videos - YouTube
Just search his videos for top 5 or something similar...

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Customer no	Denomination	*	Unique Customer No's	Customer no	1	2	3	4	5	*
2	8130038377	130	*	4	8130038377	130	100	100	*	*	*
3	8130038377	100	*	*	8130038380	60	50	50	*	*	*
4	8130038377	100	*	*	8130039898	50	*	*	*	*	*
5	8130038380	60	*	*	8130038389	70	60	50	30	*	*
6	8130038380	50	*	*	*	*	*	*	*	*	*
7	8130038380	50	*	*	*	*	*	*	*	*	*
8	8130039898	50	*	*	*	*	*	*	*	*	*
9	8130038389	60	*	*	*	*	*	*	*	*	*
10	8130038389	50	*	*	*	*	*	*	*	*	*
11	8130038389	70	*	*	*	*	*	*	*	*	*
12	8130038389	30	*	*	*	*	*	*	*	*	*
13	*	*	*	*	*	*	*	*	*	*	*
Sheet4

The formula in E2 needs to be copied down.
The formula in F2 needs to be copied across and down.

Good luck.

Ak

 

[Aladin Akyurek]

Hi,

i have some data where i want top 5 denomination of 1 customer no. there is huge data with customer no. & it's denomination.

Data is like below.

Customer no. Denomination
[TABLE="width: 173"]
<TBODY>[TR]
[TD="align: right"]8130038377
[/TD]
[TD="align: right"]130
[/TD]
[/TR]
[TR]
[TD="align: right"]8130038377
[/TD]
[TD="align: right"]100
[/TD]
[/TR]
[TR]
[TD="align: right"]8130038377
[/TD]
[TD="align: right"]100
[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380
[/TD]
[TD="align: right"]60
[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380
[/TD]
[TD="align: right"]50
[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380
[/TD]
[TD="align: right"]50
[/TD]
[/TR]
[TR]
[TD="align: right"]8130039898
[/TD]
[TD="align: right"]50
[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389
[/TD]
[TD="align: right"]60
[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389
[/TD]
[TD="align: right"]50
[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389
[/TD]
[TD="align: right"]70
[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389
[/TD]
[TD="align: right"]30
[/TD]
[/TR]
</TBODY>[/TABLE]


Pls help in this

rgds
Vishan

What would be the Top 2 denomination for 8130038377, given your sample above?

 

[vishan]

What would be the Top 2 denomination for 8130038377, given your sample above?

thankx