Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup macro
Hi,
I have two sheets and need to compare them: 1. The first sheet looks similar to: Group EVENT START DATE 1 A 12-Jan-08 1 B 22-Feb-08 1 C 12-Mar-08 1 D 19-Nov-08 2 E 25-Nov-08 2 A 25-Dec-08 2 G 25-Jan-09 2 B 25-Feb-09 2. The second sheet looks like: Group Attendance Attendance Label 1 15-Dec-07 V1 1 10-Jan-08 V2 1 13-May-08 V3 1 20-Aug-08 V4 1 20-Dec-08 V5 2 25-Aug-08 V1 2 30-Dec-08 V2 2 15-Jan-09 V3 2 30-Mar-09 V4 I need to compare the event of each group against the Attendance dates i.e. to find out between which attendance label the event occurred. the comparison should yield the following: Group EVENT START DATE 1st 2nd Closest Closest Attendance Attendance Label label 1 A 12-Jan-08 V1 V2 1 B 22-Feb-08 V2 V3 1 C 12-Mar-08 V2 V3 1 D 19-Nov-08 V4 V5 2 E 25-Nov-08 V1 V2 2 A 25-Dec-08 V1 V2 2 G 25-Jan-09 V2 V3 2 B 25-Feb-09 V2 V3 I can compare using array formulas, but with large amout of data the, not able to get the results right. Is there a macro that can be written. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup macro | Excel Discussion (Misc queries) | |||
How to create a macro to help with lookup. | Excel Worksheet Functions | |||
Macro to lookup duplicates | Excel Worksheet Functions | |||
lookup macro?? | Excel Worksheet Functions | |||
Macro lookup | Excel Discussion (Misc queries) |