I’m using a “INDEX / MATCH” formula to pickup only the last 100 entries - thus keeping my information current...
=INDEX(WORK!M:M,MATCH(99^99,WORK!$A:$A,1)-100+(ROW(WORK!M2)-1))
and it works great except when a cell is blank it'll place a "0"
I need to modify the formula to show the blank cells instead of picking up 0’s since some cells contain “0”…any suggestions? I've tried adding "IFERROR" with no avail...
Bookmarks