I have a column of values I need to analyze. There are about 90,000 cells. Most of them are FALSE but some of them are numbers.
It looks something like this.
FALSE
FALSE
FALSE
FALSE
0.12
FALSE
FALSE
FALSE
0.182
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
0.233
FALSE
FALSE
0.300
...
I need to perform simple operations on the numerical values. (for example, 0.182 - 0.12 and then 0.3 - 0.233). I'm not sure how to scan the column for a number and then subtract it from the next number that shows up, so I figured it would be easier if I could reorganize the column to get rid of all the FALSE cells. So I want it to end up just looking like:
0.12
0.182
0.233
0.300
...
Can anyone help me to figure out how to accomplish this? Or perhaps another suggestion on how I can perform my desired operations without reorganizing the column?
Bookmarks