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

8130038377	130
8130038377	100
8130038377	100
8130038380	60
8130038380	50
8130038380	50
8130039898	50
8130038389	60
8130038389	50
8130038389	70
8130038389	30

<colgroup><col><col></colgroup><tbody>
</tbody>

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

8130038377	130
8130038377	100
8130038377	100
8130038380	60
8130038380	50
8130038380	50
8130039898	50
8130038389	60
8130038389	50
8130038389	70
8130038389	30

<TBODY>
</TBODY>

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