Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an array with over 21,000 rows. I need to analyze this but have
not been able to get it out in a useful format yet. The data looks like this: VarName TimeString VarValue Pos 27.01.2011 12:49:35 32 Pres 27.01.2011 12:49:35 -2 Setpt 27.01.2011 12:49:35 100 Gain 27.01.2011 12:49:35 1 Int 27.01.2011 12:49:35 10 Pos 27.01.2011 12:49:36 32 Pres 27.01.2011 12:49:36 -2 Setpt 27.01.2011 12:49:36 100 Pos 27.01.2011 12:49:37 32 Pres 27.01.2011 12:49:37 9 Setpt 27.01.2011 12:49:37 100 Pos 27.01.2011 12:49:38 32 Pres 27.01.2011 12:49:38 9 Setpt 27.01.2011 12:49:38 100 Pos 27.01.2011 12:49:39 32 Pres 27.01.2011 12:49:39 24 Setpt 27.01.2011 12:49:39 100 Pos 27.01.2011 12:49:40 32 Pres 27.01.2011 12:49:40 24 Setpt 27.01.2011 12:49:40 100 Gain 27.01.2011 12:49:40 1 Int 27.01.2011 12:49:40 10 I need to extract it into a format something like this in order to chart it: TimeString Pos Press Setpt Gain Int 27.01.2011 12:49:35 32 -2 100 1 10 27.01.2011 12:49:36 32 -2 100 27.01.2011 12:49:37 32 9 100 27.01.2011 12:49:38 32 9 100 27.01.2011 12:49:39 32 24 100 27.01.2011 12:49:40 32 24 100 1 10 Any help would be appreciated. I've burned up a couple of days so far with little luck. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract multiple values from array | Excel Discussion (Misc queries) | |||
Extract a column/row from a 2-D array | Excel Programming | |||
Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
How do I extract a single value from the linest array result? | Excel Worksheet Functions | |||
How do I extract hyperlink as text from an array of hyperlinks? | Excel Worksheet Functions |