Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rearranging data
Hi
I have data in the following form, with each ID having numerous events against it: ID End Date Event 1 1/1/2004 A 1 1/2/2004 B 1 1/3/2004 C 2 1/4/2004 X 2 1/5/2004 Y 3 1/6/2004 M 3 1/7/2004 N I need to pick up the last two events (by date) and organise them as follows: ID Second last date Second last event Last date Last event 1 1/2/2004 B 1/3/2004 C 2 1/4/2004 X 1/5/2004 Y 3 1/6/2004 M 1/7/2004 N Any easy way of doing this? Thanks, Utkarsh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rearranging DATA | Excel Discussion (Misc queries) | |||
Rearranging data | Excel Discussion (Misc queries) | |||
rearranging data | Excel Worksheet Functions | |||
Rearranging Data Help... | Excel Discussion (Misc queries) | |||
rearranging data | Excel Programming |