UniqueUsername1
New Member
Hello! This is my first post here so please tell me if I'm doing something wrong.
I use a variation of the array formula from the link below to get a unique distinct list:
This has worked wonderfully until now, but now I have to do the same thing with five columns. Unfortunately, every solution I could find online required the columns to be adjacent. This is not possible in my sheet. For security reasons, my organization does not allow VBA or Macros.
I have attached the sample sheet. I had to delete all unrelated data as it's sensitive. Please note that there is data in every column up to A:A.
Any help would be appreciated. Thanks in advance.
I use a variation of the array formula from the link below to get a unique distinct list:
Extract a unique distinct list sorted from A to Z
The array formula in cell D3 extracts unique distinct values sorted A to Z, from column B to column D. Unique distinct values are all values except duplicat
www.getdigitalhelp.com
I have attached the sample sheet. I had to delete all unrelated data as it's sensitive. Please note that there is data in every column up to A:A.
Any help would be appreciated. Thanks in advance.
Attachments

11.1 KB Views: 10