Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tricky Excel Problem
Please allow me to apologize for my poor suggested solution here. I didn't
read your post thoroughly enough before responding. A pivot table would not work for you here even if you rearranged the data. Please allow me to ask something, though. Excel doesn't like that date format and some of your data has leading zeros. Are you in a position to massage that data a little bit to make the dates more Excel-friendly and lose the leading zeros, or do you have to have a solution that cleans up the data and also gives you the results you want? -- RMC,CPA "R. Choate" wrote in message ... I would start with a pivot table on the data before I write any code. That should yield the info you are looking for. -- RMC,CPA "J P Singh" <noemail@asIhatespam wrote in message ... Hi All Can someone please help me put a solution in place for this problem. We have two lists of data which we need to match. We loan out phones to our business users who use them for fixed number of days and then return them to us. This data is stored in one worksheet as Mobile Number Date From Date To User Prod Number 07855422282 12/03/2003 13/03/2003 Kiersty Smith 33089320 07855422282 23/04/2003 27/04/2003 Kiri Belcher 33097720 07855422282 19/06/2003 20/06/2003 Tim Day 10130610 07855412282 01/07/2003 05/07/2003 Jackie O'Shea 33453410 07855412282 07/08/2003 09/08/2003 Rhodi Evans 334616 ETW 07855412282 14/01/2003 16/01/2003 Andrew Orr 901101103 Once the users have used the phones we get a bill from our phone company data in which looks like Phone No Date Total Cost 07855422282 12/3/03 1.54 07855422282 13/3/03 1.20 07855422282 23/4/03 0.58 07855422282 24/4/03 1.45 07855422282 25/4/03 0.00 07855422282 26/4/03 0.96 07855422282 27/4/03 1.99 07855412282 07/8/03 1.54 07855412282 08/8/03 2.58 07855412282 09/8/03 0.58 07855412282 14/1/03 1.29 07855412282 15/1/03 2.66 What I need to do is to find out what was the total cost of calls for a particular user for the time he has had the phone. I am sure this can be done through VBA but not sure how to start. Then results should look something like Mobile Number Date From Date To User Total Cost 07855422282 12/03/2003 13/03/2003 Kiersty Smith £2.74 07855422282 23/04/2003 27/04/2003 Kiri Belcher 07855422282 19/06/2003 20/06/2003 Tim Day 07855412282 01/07/2003 05/07/2003 Jackie O'Shea 07855412282 07/08/2003 09/08/2003 Rhodi Evans 07855412282 14/01/2003 16/01/2003 Andrew Orr Can you offer some help please. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky Excel De-Dupe Problem | Excel Worksheet Functions | |||
tricky sum problem | Excel Discussion (Misc queries) | |||
Tricky problem in Data validation - Excel 2003 | Excel Discussion (Misc queries) | |||
Tricky Excel Problem | Excel Programming | |||
Tricky Excel Problem | Excel Programming |