Forum Discussion

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
Mar 15, 2023
RVXAC You may use the following formula-
=IF(COUNTA(UNIQUE(A2:A15))=1,UNIQUE(A2:A15),">1 Month")

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

Copper Contributor

Mar 15, 2023

Harun24HR

Actually, I think I got it.

Your formula helped start me off with the logic of it, and I was able to come up with this formula, which seems to work:

=IF(A2=0,"No data imported.",IF(COUNTA(UNIQUE(A2:A15))>1,">1 Month",IF(COUNTA(A2)=1,A2,"No data imported.")))

It may not be pretty, but at least it's working!

Thanks so much again.
Richard

Harun24HR
Bronze Contributor
Mar 16, 2023
If that help, you can tick mark the answer so that thread can be treated as solved.