Forum Discussion

RVXAC's avatar
RVXAC
Copper Contributor
Mar 15, 2023
Solved

Formula to output value from a column, or show a text output if more than 1 distinct value in column

Hello!   So sorry if this has an obvious answer. I've been googling for hours and cannot figure this out so I've decided to ask.   In my workbook, I have a sheet containing tables in which the da...
excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Mar 15, 2023

    RVXAC You may use the following formula-

    =IF(COUNTA(UNIQUE(A2:A15))=1,UNIQUE(A2:A15),">1 Month")

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Mar 15, 2023

RVXAC You may use the following formula-

=IF(COUNTA(UNIQUE(A2:A15))=1,UNIQUE(A2:A15),">1 Month")

 

RVXAC's avatar
RVXAC
Copper Contributor
Mar 15, 2023

HelloHarun24HR 

 
Thanks so much for your reply, this does exactly what I asked for!

 

The one problem is, I forget to mention that I wanted the cell to display "No data" if there was no data in the table.

 

Once again, I tried modifying the formula you have provided but I did not have success in adding this additional feature. Any thoughts on how I can modify the formula?

 

Thanks so much again.
Richard

Resources