We help IT Professionals succeed at work.

Create list of unique items without empty rows

127 Views
Last Modified: 2019-01-29
Using this formula, I can get an idea of which rows are distinct:
=IF(COUNTIFS($H$2:$H2,$H2)=1,"Distinct","")

Open in new window

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?
Comment
Watch Question

Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:
if you're subscribed as Office Insider, you should able to use the new feature UNIQUE to get unique value list.

UNIQUE function
https://support.office.com/en-us/article/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.