Link to home
Start Free TrialLog in
Avatar of Russ Suter
Russ Suter

asked on

Create list of unique items without empty rows

Using this formula, I can get an idea of which rows are distinct:

Open in new window

Using this formula I can create this:
User generated imageThe 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:
User generated imageHow can I do that?
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
if you're subscribed as Office Insider, you should able to use the new feature UNIQUE to get unique value list.

UNIQUE function