Help me

surenderitft

New Member
Joined
Sep 19, 2014
Messages
5
CustomerNumber
Transaction Number
Nationality
Payout Amount
Month
0000145813216846
1788321871326805
American
7020.24
Feb-13
0000145813216847
1788311851329507
British
14636.99
Jul-13
0000145813216845
1788391841340531
Bangladeshi
70018.4
Jul-13
0000145813216846
1788341751324552
American
11043.22
Mar-13
0000145813216841
1788381671348859
UAE
30000
Jun-13
0000145813216846
1788391661319962
American
14663.38
Jun-13
0000145813216845
1788311631324538
Bangladeshi
34025.56
Jun-13
0000145813216847
1788311631320102
British
12082.34
Jun-13
0000145813216841
1788371621319209
UAE
12119.03
Jun-13
0000145813216840
1788391621319181
Bangladeshi
17085.85
Jun-13
0000145813216841
1788301621319126
UAE
17309.35
Jan-14
0000145813216846
1788371311325306
American
40014.16
May-14

Hi
I just want to find out the a particular customer transaction frequency, please help me how I should find out
like customer no 0000145813216846 has done 4 transaction and also want transaction month, like Feb 13, march 14, june 13 and may 13 and accumulated amount of all 4 transaction in a particular column

 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

surenderitft

New Member
Joined
Sep 19, 2014
Messages
5
yes pivot table , but i need to find out the transaction frequency month on each customer. office 2010 window 7 professional i'm using.
 

surenderitft

New Member
Joined
Sep 19, 2014
Messages
5

ADVERTISEMENT

counts i can find easily from pivot table ..but i need to find transaction frequency of each customer with month name and accumulated payout amount .....for instance this customer 0000145813216846 has done four transaction since jan 2013 to july2014 , transaction count i can get from pivot table but i'm not able to find the frequency (4 months in jan2013 format ) can anyone help me in this matter ..which formula i should use to find the transactions month or months ..
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
read up on sumproduct for each account you can count transactions occurring in each month
 

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,466
Members
409,883
Latest member
asharris90
Top