Forum Discussion
Grouping
Is there a way to group by just the column with the data in it? I have 20k+ rows of data. I need to label in Col A based upon the group in Col AK. I have already sorted the data so that the top ro...
Since your data is sorted, you can test for any changes between rows by 'pushing' the data down a row and comparing before and after.
= IF(data <> VSTACK(0, DROP(data,-1)), "Group: "& data, "")To test multiple fields for changes you would need to introduce BYROW and OR functions.