Hi all,
I'm trying to analyse a customer's bill and struggling to Summarise how many days each individual has made a call to the follwing zones.
please see sample spreadsheet attched.
I just want to know for example malkeet has roamed 11 days and he made calls to these zones based on the data i have. Not sure if pivot table is the best option or if i need a formula?
Thank you for your help in advance
Not sure about the result, since you didn't add them in you file.
I made an example with info with an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi
Thank you for taking the time out to reply.
Apologies for not being clear earlier.
So looking at the data, i can see david chopping made calls on 3 days all in EU preferred Zones and they were both peak and off peak.
the number of days is the key here. I want to be able check for each user, how many days they were making calls (the number of calls are irrelavent) and which zones. Hope this makes sense?
Another example.
Otherwise add manual the result in the sheet (AND refer to the cells who are related).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks