I currently have a line header and associated numbers exported into excel in the same column.
The following example is currently in one column. I need to separate and expand these into two columns.
Example:
LINE ABC
3030C
10026A
10026B
10026C
LINE ABH
7595
7644
11146
16837
16838...
Using excel 2010 and trying to count the number of occurrences of numbers with specific endings in a column.
Column Example:
0.69
1.99
0.54
39.99
39.97
How many times does a number end in .99? If all went well the output would be 2. Been trying to use wildcards- but it doesnt seem to...