Comparing multiple text strings and ignoring blanks

[BM1988]

I have a file consisting of 12 columns and several Thousand rows of which not all cells are filled, but the cells that are filled are Always text strings.

I want to have a formula that PER ROW compares the text strings (thus ignoring blanks) of each filled cell and gives:
- The text string in case all cells are filled equal
- an error message in case all cells are not filled equal

Any ideas?

[mrice]

Try this user defined function

Please Login or Register  to view this content.

Open the VBA editor by hitting Alt F11.
Insert a new module with Insert - Module
Paste in the above function
Go back to the sheet by hitting Alt F11.

In a M2 enter =AllTheSame(A1:L1)

Remember to save the workbook as a macro enabled workbook .xlsm

[BM1988]

Is there any way to do this without using macros? So using just formulas.