Top 5 Denomination

vishan

New Member
Joined
Mar 11, 2011
Messages
14
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
8130038377130
8130038377100
8130038377100
813003838060
813003838050
813003838050
813003989850
813003838960
813003838950
813003838970
813003838930

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


Pls help in this

rgds
Vishan
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
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
ABCDEFGHIJK
1Customer noDenomination*Unique Customer No'sCustomer no12345*
28130038377130*48130038377130100100***
38130038377100**8130038380605050***
48130038377100**813003989850*****
5813003838060**813003838970605030**
6813003838050*********
7813003838050*********
8813003989850*********
9813003838960*********
10813003838950*********
11813003838970*********
12813003838930*********
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,366
Messages
5,601,208
Members
414,434
Latest member
Riyen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top