cancel
Showing results for 
Search instead for 
Did you mean: 

Itemised Phone Bill Checker

dingodrum
Newbie
Posts: 5
Thanks: 3
Registered: ‎23-05-2010

Itemised Phone Bill Checker

Is there such a thing?
I've noticed that quite a few European phone companies provide the same to make splitting a bill between house-mates a little easier.....
7 REPLIES 7
Oldjim
Community Veteran
Posts: 38,460
Thanks: 1,034
Fixes: 63
Registered: ‎15-06-2007

Re: Itemised Phone Bill Checker

There is a completely itemised bill and you can also download a copy in csv format so you can analyse it in Excel or Open Office Calc
pierre_pierre
Grafter
Posts: 19,757
Registered: ‎30-07-2007

Re: Itemised Phone Bill Checker

that is available on BT as well as on Plusnet home phone
and welcome to the Forum
dingodrum
Newbie
Posts: 5
Thanks: 3
Registered: ‎23-05-2010

Re: Itemised Phone Bill Checker

Thanks for the answers and the welcome!
There are a few things around for this sort of  thing, I'm struggling to find a decent excel template.  But I guess I'll have to make one!  Wink
pierre_pierre
Grafter
Posts: 19,757
Registered: ‎30-07-2007

Re: Itemised Phone Bill Checker

just open the CSV file in excell and all the info will be in headed columns, you can then sort the info (Data sort) on the number
dingodrum
Newbie
Posts: 5
Thanks: 3
Registered: ‎23-05-2010

Re: Itemised Phone Bill Checker

Yea, I know I can do that.
What I was after is to have for example column 'A' to have the numbers called and column 'B' to have the numbers from my phone.  Then for excel to highlight in column 'A' what is in column 'B' so I can see what I owe.
Then I could do it for the other 6 people in the house, just to make it a little quicker now and in the future.  - It's been a few months since we went through it last time you see.
I'm working on it now...
Oldjim
Community Veteran
Posts: 38,460
Thanks: 1,034
Fixes: 63
Registered: ‎15-06-2007

Re: Itemised Phone Bill Checker

You could use the vlookup command or even better try using pivot tables
Strat
Moderator
Moderator
Posts: 31,295
Thanks: 3,878
Fixes: 565
Registered: ‎14-04-2007

Re: Itemised Phone Bill Checker

I would create a sheet with a list of contact numbers from my phone and use vlookup as Jim says.

Customer and Forum Moderator. Windows 10 Firefox 105.0.1 (64-bit (64-bit)