UNIQUE function returning 0

thewiseguy

Well-known Member
Joined
May 23, 2005
Messages
773
Office Version
365
Platform
Windows
Depends on what columns you changed the formatting on. ;)
lol ok so anything in column X that does not have a value is coming back as '0'. i had the hide option engaged. can i remove the zero and not hide it? i'm having trouble finding a way to do this with a formula.
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,669
Office Version
365
Platform
Windows
With this formula in X
=IF(N2="Yes","",Q2)

You should only get a 0 if N2 is not Yes & Q2 is empty
 

thewiseguy

Well-known Member
Joined
May 23, 2005
Messages
773
Office Version
365
Platform
Windows
With this formula in X
=IF(N2="Yes","",Q2)

You should only get a 0 if N2 is not Yes & Q2 is empty
yes, that is the exact case. column Q needs to be empty in certain instances. is there a workaround?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,669
Office Version
365
Platform
Windows
In that case use
=SORT(UNIQUE(FILTER(INPUT!X2:X200,(INPUT!X2:X200 <>"")*(INPUT!X2:X200<>0),FALSE)))
 

Watch MrExcel Video

Forum statistics

Threads
1,102,351
Messages
5,486,361
Members
407,541
Latest member
Emilybuhman

This Week's Hot Topics

Top