Forum Discussion

RJF61's avatar
RJF61
Copper Contributor
Jul 03, 2023
Solved

Use UNIQUE only on cells contain Info

I was using the UNIQUE function to identify duplicate values from the left column.  In my case I was using a range (ex: A1:A50) so that new values would be be included (dynamic use).  Is there a way ...
  • Patrick2788's avatar
    Jul 03, 2023

    RJF61 

    You can use TOCOL to pull the blanks as such:

    =UNIQUE(TOCOL(A1:A50,1))

Resources