Most common text formula

SharonR

IS there a formulas that collect the most common text in range of cells?

 

I want a parent line to show the most common option in that column.

 

 

Andrée Starå

Hi Sharon,

Are the values predefined?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting​