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

    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's avatar
      Harun24HR
      Bronze Contributor
      Mar 16, 2023
      If that help, you can tick mark the answer so that thread can be treated as solved.
  • 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