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$10
JHA-App-3.xlsx
JHA1 Cell G2 {=IFERROR(INDEX($D$4:$D$10
JHA-App-3.xlsx
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
Last Comment
Subodh Tiwari (Neeraj)
Did you try either of my suggestions on your previous question, zeroes weren't an issue with my suggestions.
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.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
The chosen answers resolved the original question.