Hi guys, I'm running into a wall with this. Is there a way for a dropdown list to not return entries with zeroes? I have something like Product A, Product B, 0, Product C, 0. I'd like to have the zeroes not show up, is there anything I can add to my formula to get them out of there? Thanks!!
This is my formula I'm using right now:
=OFFSET('SELECTED OPT'!$N$1,0,0,COUNTA('SELECTED OPT'!$N:$N),1)
This is my formula I'm using right now:
=OFFSET('SELECTED OPT'!$N$1,0,0,COUNTA('SELECTED OPT'!$N:$N),1)