| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Matching
Hi We want to be able to match number plates using excel and creating an output file that shows the time difference between the two number plates. The file we get in is like this Site Vehicle Type Reg Plate Time (Hour) Time (Min) 001 1 T890RFW 07 00 001 1 FL51FYZ 07 00 001 1 KC04PZG 07 00 001 1 P610APB 07 00 001 1 P676JKP 07 00 001 1 FG51OZB 07 00 001 1 P849GAL 07 00 001 1 R787KHP 07 00 001 1 FH52SUD 07 00 001 1 X591BAU 07 00 001 1 P258UVK 07 00 001 1 BS2200 07 01 001 1 R142GWO 07 01 002 1 FH52SUD 07 20 002 1 FG51OZB 07 29 and it needs to come out like this Entry Place Exit Place Time Number Plate Any help with this would be greatly appreciated. If more clarrification is needed pls msg and i will try my best. Skyhigh -- Skyhigh ------------------------------------------------------------------------ Skyhigh's Profile: http://www.excelforum.com/member.php...o&userid=24907 View this thread: http://www.excelforum.com/showthread...hreadid=384449 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching ids help | Excel Discussion (Misc queries) | |||
| Matching | Excel Discussion (Misc queries) | |||
| Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Threaded Mode
