Dear all, I am using below formula for getting unique values, it is working fine except getting one Zero, below the formula & unique values example.
here CELL B formula output is ok except Zero . I don't want to get Zero in the CELL B.
Please Login or Register to view this content.
Last edited by nur2544; 05-03-2019 at 01:51 PM.
maybe try this NON Array formula instead... =IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$20&""),),0)),"")
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hi Sambo kid, Thanks for replay, I have tried your formula but still I am getting Zero.
is there something in B1? because if nothing is in that cell I just get the list, but if I put something in B1 I get zeros.
Hi All,
I completely agree with Sambo kid. If B1 has some text (it's not empty), maybe a small appendix could be of some help to hide zeros.
=IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$20&""),),0))&"","")
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
canapone, NICE! Mind if I steal that?
Hi Sambo kid, yes there are some text in B1 , but it is required for head line. Thanks for your support .
Hi Canapone, your formula is working perfectly. I appreciated it. It will help me a lot.Originally Posted by canapone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks