Dears,
I have an excel sheet that has customer records. the customer records are sorted out by branch number...like:
501 customer A
501 Customer B
501 Customer C
502 Customer D
502 Customer E
503 Customer F
504 Customer G
504 Customer G
And I would like to know the number of records each branch has via formula. I used count IF, COUNTIF(range, criteria) and I got the value for branch 501. how can drag and get a result that looks like
Branch 501 502 503 504
records 3 2 1 2
Thank you very much.
Last edited by Vitorio; 08-19-2013 at 07:17 AM.
Use Pivot Table bye leaving the branch # in Column Header and customer name header in Data Area.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
The formula i use is =COUNTIF($A$2:$A$450,"501")
I need to be able to drag the cell and while doing that, "501" should change to "502" and so on.....how can i do that?
If you're dragging the formula down a column try this...
=COUNTIF($A$2:$A$450,ROWS(A$1:A501))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
It worked sixthsense way.
Thanks fellas, great help....appreciate it
Try this file.
Last edited by ramananhrm; 08-19-2013 at 07:36 AM.
Please click 'Add reputation', if my answer helped you.
Actually i didn't know how to use it >.<;;
I'm a beginner I admit it.
if you please can simplify it.
and btw 501 is in a column, customer name is in another and so on
so that range is fixed for the branch codes from A1 to A* but all I need is to create something like you did, a branch list with the number of records under each branch.
Or
Check the attachment file for both formula and Pivot Table solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks