troubleshooting Question

Create list of unique items without empty rows

Avatar of Russ Suter
Russ Suter asked on
Microsoft OfficeSpreadsheetsMicrosoft Excel
2 Comments1 Solution136 ViewsLast Modified:
Using this formula, I can get an idea of which rows are distinct:
=IF(COUNTIFS($H$2:$H2,$H2)=1,"Distinct","")
Using this formula I can create this:
Unique ListThe problem here is that it contains blank lines. What I really need is a list of distinct values without any spaces in between like this:
Condensed Unique ListHow can I do that?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros