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
Table of Contents Extract a unique distinct list sorted from A to Z Unique distinct list sorted alphabetically based on a condition - Earlier Excel ve
www.get-digital-help.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.