C
Chris
I am trying to find a way to tie together several
workbooks of data to create charts and stats. The
consolidate function is the
closest I've come to a solution. I need to create charts
and statistical analysis for columns of data that can be
any of the following: number(1,2,3,..etc), Add, Drop, d,
a, N(and a number together), Add(and a number), drop(and
a number), a(and a number), d(and a number).
My problems is that my data is not strictly numbers. It
sometimes contains a letter or a word before the number.
Is it possible to count values like N1, Add3, drop4, 4,
a5, d8 and be able to analyze the number of occurances
of Add, drop, a, or d? If this isn't clear I would be
happy to elaborate further. I can also email you a copy
of the worksheet I am working with.
Your help will be greatly be appreciated!
..
workbooks of data to create charts and stats. The
consolidate function is the
closest I've come to a solution. I need to create charts
and statistical analysis for columns of data that can be
any of the following: number(1,2,3,..etc), Add, Drop, d,
a, N(and a number together), Add(and a number), drop(and
a number), a(and a number), d(and a number).
My problems is that my data is not strictly numbers. It
sometimes contains a letter or a word before the number.
Is it possible to count values like N1, Add3, drop4, 4,
a5, d8 and be able to analyze the number of occurances
of Add, drop, a, or d? If this isn't clear I would be
happy to elaborate further. I can also email you a copy
of the worksheet I am working with.
Your help will be greatly be appreciated!
..