I have data in a column that is dynamic and that may be either text or number. The values within the column are "grouped" by cells containing "" values resulting from an IF condition, i.e., ISBANK=FALSE, but the cell shows as empty.
An example data set would be the following:
7
5
3
11
9A
15
13
25B
23
21
19
17
I would like to find the most efficient way to go to a new column in a new sheet and reverse the numbers within each group, but keep the order of the groups unchanged. The result would be:
3
5
7
9A
11
13
15
17
19
21
23
25B
I'm at a bit of a loss here. I've been toying with it for a while now, but without much luck.
Can anyone get me headed in the right direction?
Bookmarks