Forum Discussion

Amlesh7400's avatar
Amlesh7400
Copper Contributor
May 03, 2021

Find Common Values In ALL 5 Columns With Array Formulas

Hello,  I have test data of 101 rows containing 3 or 4 Alphabet symbols in 5 columns. Some of these 3 or 4 letter symbols can be found across all 5 columns though not in the same row e.g. "BDRY" can...
  • Riny_van_Eekelen's avatar
    May 03, 2021

    Amlesh7400 Perhaps easiest with Power Query. In the attached workbook you'll find a sheet called "Count". I trust you can do your analysis from there.

Resources