Hi,
Have a look in the attached file.
HTH :)
---
Ms.Exl.Learner
---
On Tue, Feb 1, 2011 at 12:22 AM, jmccaski wrote:
> I have an arry of over 21,000 rows with data in this format:
> VarName TimeString VarValue
> Pos 27.01.2011 12:49:35 32
January 31, 2011 1:52:55 PM
Subject: $$Excel-Macros$$ How to extract data from an array
I have an arry of over 21,000 rows with data in this format:
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 2
Hi,
If you kindly put the data in excel it would be easy.
Reg
Umesh
On Tue, Feb 1, 2011 at 12:22 AM, jmccaski wrote:
> I have an arry of over 21,000 rows with data in this format:
> VarName TimeString VarValue
> Pos 27.01.2011 12:49:35 32
> Pres27.01.2011 12:49:35 -2
> Set
I have an arry of over 21,000 rows with data in this format:
VarName TimeString VarValue
Pos 27.01.2011 12:49:35 32
Pres27.01.2011 12:49:35 -2
Setpt 27.01.2011 12:49:35 100
Gain27.01.2011 12:49:35 1
Int 27.01.2011 12:49:35 10
Pos 27.01.2011 12:49:36