Link to home
Create AccountLog in
Avatar of cssc1
cssc1Flag for United States of America

asked on

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
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Did you try either of my suggestions on your previous question, zeroes weren't an issue with my suggestions.
Avatar of cssc1

ASKER

I may be using the drop-down selection but I don't like pivot tables
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.
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
The chosen answers resolved the original question.