Forum Discussion

TRiceGMH's avatar
TRiceGMH
Copper Contributor
Dec 20, 2024

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...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 21, 2024

With the information you shared it's virtually impossible to answer your question... See if the following helps in the meantime

  • Data formatted as Table named TableSource
  • In column [Event ID] formula is (copied down):
=IF( COUNTIF( SourceTable[[#Headers],[Group]]:[@Group], [@Group] ) = 1, [@Group], "" )
  • Filter [Event ID] unchecking (Blanks)

Resources