Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A formula to ponder on - I burnt myself out !
I have a problem in generating a formula that would work on the following
sheet: Truck Time Radial Acc Time Out On Site Off Site Time In C1 10:20 4 B023 10:27 11:50 12:00 12:35 C2 09:55 11 F0512 10:00 10:10 10:55 11:50 CF 06:00 8 K0232 06:00 08:00 08:20 09:00 C7 09:55 3 A0022 09:55 10:10 10:35 11:00 C2 12:03 17 M0005 12:10 13:15 13:30 14:55 C1 13:00 3 O0150 13:10 13:50 14:00 14:15 and so on .... This would be on up to 31 different sheets in a file which each sheet would represent the date of the month. What I am looking for is a formula that would pull the information for a paticular truck code for the whole month on to 1 sheet so as to compare the length of time for a particular Acc (Account). The data on the above sheet cannot be sorted or moved as this information is taken from dockets. Much appreciate any help. I was trying to use the vlookup formula but to no avail as it was only picking up the first instance of the truck code and not the next one etc. This is urgent for me so I do appreciate any quick replies. Regards -- Richie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A formula to ponder on - I burnt myself out !
On Jun 19, 5:35 am, Richie wrote:
I have a problem in generating a formula that would work on the following sheet: Truck Time Radial Acc Time Out On Site Off Site Time In C1 10:20 4 B023 10:27 11:50 12:00 12:35 C2 09:55 11 F0512 10:00 10:10 10:55 11:50 CF 06:00 8 K0232 06:00 08:00 08:20 09:00 C7 09:55 3 A0022 09:55 10:10 10:35 11:00 C2 12:03 17 M0005 12:10 13:15 13:30 14:55 C1 13:00 3 O0150 13:10 13:50 14:00 14:15 and so on .... This would be on up to 31 different sheets in a file which each sheet would represent the date of the month. What I am looking for is a formula that would pull the information for a paticular truck code for the whole month on to 1 sheet so as to compare the length of time for a particular Acc (Account). The data on the above sheet cannot be sorted or moved as this information is taken from dockets. Much appreciate any help. I was trying to use the vlookup formula but to no avail as it was only picking up the first instance of the truck code and not the next one etc. This is urgent for me so I do appreciate any quick replies. Regards -- Richie Try an Advanced Filter instead of VLOOKUP. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|