A formula to ponder on - I burnt myself out !

R

Richie

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
 
S

Spiky

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

Try an Advanced Filter instead of VLOOKUP.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top