Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table? ID, Date, Value sorting
Hi
Excel 03 I'm wondering if a Pivot Table is the way to go. I have data in this format ID, Date, Value1, Value2, Value3, Value4, Value5 Each ID has Values by different dates usually a maximum of 5 dates. I want the most recent Value by date for each ID from each column - Value1, Value2, Value3 etc For example, for ID 02 below would be as at 0712: ID Date V1 V2 V3 V4 V5 02 0712 40 20 30 05 10 Now I need to extract this data to a spreadsheet to import into another application Many thanks Mark EG of data (BTW Values are percentages) ID Date V1 V2 V3 V4 V5 01 0612 12 22 45 01 0712 14 40 22 50 02 0610 50 15 20 10 05 02 0612 45 30 05 10 02 0712 40 20 30 10 03 ... 03 ... 03... 03 ... 04... 04... 05... 05... 05... etc to 600 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Sorting | Excel Worksheet Functions | |||
Pivot Table Sorting | Excel Worksheet Functions | |||
PIVOT Table Sorting - PLEASE Help!!!!! | Excel Discussion (Misc queries) | |||
pivot table sorting | Excel Worksheet Functions | |||
Pivot Table sorting | Excel Discussion (Misc queries) |