Remove zero form colum

how to remove "ZERO" when using this formula on sheet JHA1

 JHA1 Cell G2 {=IFERROR(INDEX($D$4:$D$100, MATCH(0,COUNTIF($G$1:G1, $D$4:$D$100), 0)),"")} ctrl+shift+Entre...Drop Down
JHA-App-3.xlsx
cssc1Asked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Just Custom Format the formula cell with 0;-0;;@
Please refer to the attached.
JHA-App-3.xlsx
1
 
Rob HensonFinance AnalystCommented:
Did you try either of my suggestions on your previous question, zeroes weren't an issue with my suggestions.
0
 
cssc1Author Commented:
I may be using the drop-down selection but I don't like pivot tables
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Rob HensonFinance AnalystCommented:
I used to also dislike pivot tables but mostly because I didn't know enough about them.

I now use them fairly frequently. Once it is created, it is pretty much self sufficient. The range of the source data might change but this can be allowed for with a dynamic range.
0
 
abbas abdullaCommented:
Hi,

If you want only values of text without having the zero or blank in middle, then you can use this array formula =IFERROR(VLOOKUP(SMALL(IF($B$4:$B$34=TRUE,$A$4:$A$34,""),ROW(A1)),$A$4:$D$34,4,0),"")
Check the attached file - Column H
JHA-App-3.xlsx
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The chosen answers resolved the original question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.