# Help me

#### surenderitft

##### New Member
 CustomerNumber
 Transaction Number
 Nationality
 Payout Amount
 Month
 0000145813216846
 1788321871326805
 American
 7020.24
 Feb-13
 0000145813216847
 1788311851329507
 British
 14637
 Jul-13
 0000145813216845
 1788391841340531
 70018.4
 Jul-13
 0000145813216846
 1788341751324552
 American
 11043.2
 Mar-13
 0000145813216841
 1788381671348859
 UAE
 30000
 Jun-13
 0000145813216846
 1788391661319962
 American
 14663.4
 Jun-13
 0000145813216845
 1788311631324538
 34025.6
 Jun-13
 0000145813216847
 1788311631320102
 British
 12082.3
 Jun-13
 0000145813216841
 1788371621319209
 UAE
 12119
 Jun-13
 0000145813216840
 1788391621319181
 17085.8
 Jun-13
 0000145813216841
 1788301621319126
 UAE
 17309.3
 Jan-14
 0000145813216846
 1788371311325306
 American
 40014.2
 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

### Excel Facts

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.

#### CharlesChuckieCharles

##### Well-known Member
Isn't this just a pivot table?

#### surenderitft

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

#### oldbrewer

##### Board Regular
pivot table with count of payout in the middle

#### surenderitft

##### New Member

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
to find transactions per month for each customer use sumproduct

#### surenderitft

##### New Member
want to find out transaction frequency .......actually transaction happening months ..\

#### oldbrewer

##### Board Regular
read up on sumproduct for each account you can count transactions occurring in each month

Replies
34
Views
443
Replies
8
Views
66
Replies
2
Views
24
Replies
0
Views
30
Replies
5
Views
66