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 utilize UNIQUE only on cells that contain a value?

 

IAQT2CREWCF2
ETECHETECH
IAQT2GENERAL2
GENERAL2IAQT2
GENERAL20
GENERAL2 
IAQT2 
IAQT2 
ETECH 
ETECH 
CREWCF2 

Resources