Remove Zero Value from Cell

[mbrown279]

Hi All,

I am using an Index/Match to look up value from another table, and using that data to pivot out average scores. However it is placing zeros in the filed that have no data, which is causing Excel to count that cell.

What would I need to do so that a zero value is not returned and counted by Excel when pivoting out the data get the average score. I hope I have explained this properly.

=IF(ISNA(INDEX(Updated[NPS],MATCH([Conversation ID],Updated[Conversation ID],0))),"",INDEX(Updated[NPS],MATCH([Conversation ID],Updated[Conversation ID],0)))

I set up the pivot table to show count so I could see the difference between the current score and update score. The updated score is the one using the formula. It should be the same number.

Current Score	Updated
2	152
947	1933
693	1193
545	1079
624	1045
542	1021
230	446
763	1472
45	862
444	746
1015	1936

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[yky]

You can always set the if statement to return a null string.

=IF(MyIF=0,"",MyIF) 'where MyIF is your IF statement.

 

[Phuoc]

Or try:

=IFERROR(1/(1/"your_formula"),"")