If INDEX formula shows 0 then leave cell blank

**Rwe5ty1** · 04-22-2015, 05:44 AM

I have an Index formula which is looking up data from a large table, and then showing the data in chronological order in the table column (Test results from the past 2 years). But not all the dates have a data entry and show up 0.

I want to have the dates which have a 0 value for specific tests to show BLANK so I can use the MIN or MAX function to discount the 0 values and only find the MIN or MAX from the relevant data..OR can I manipulate the MIN formula to discount 0 values?

Help appreciated thank you

**Glenn Kennedy** · 04-22-2015, 06:10 AM

I can't see what you've got... but couldn't you use=if(yourformula=0,"",yourformula)

**Rwe5ty1** · 04-22-2015, 06:27 AM

So far I have just used an IFERROR so the formula is...

=IFERROR(INDEX(CSGData[CMJ1],$D4),"")

**Rwe5ty1** · 04-22-2015, 06:34 AM

Just used

=IF(INDEX(CSGDATA[CMJ1],$D4)=0,""(INDEX(CSGDATA[CMJ1],$D4))

Worked Perfectly thanks!!

**Glenn Kennedy** · 04-22-2015, 07:11 AM

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.