Forum Discussion
RJF61
Jul 03, 2023Copper Contributor
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?
IAQT2 | CREWCF2 |
ETECH | ETECH |
IAQT2 | GENERAL2 |
GENERAL2 | IAQT2 |
GENERAL2 | 0 |
GENERAL2 | |
IAQT2 | |
IAQT2 | |
ETECH | |
ETECH | |
CREWCF2 |
3 Replies
Sort By
- Patrick2788Silver Contributor
- RJF61Copper Contributor
Thanks, worked perfectly!
- Patrick2788Silver ContributorYou're welcome!