re: maybelle's approach - I think you could adapt the COUNT to a COUNTIF (ie we're assuming 0 not blank) and thus use:
=IF(B1=0,0,INDEX($B$1:$B$4,COUNTIF($B$1:$B$4,"<>0")))
again though assuming 0 to never be valid
re: maybelle's approach - I think you could adapt the COUNT to a COUNTIF (ie we're assuming 0 not blank) and thus use:
=IF(B1=0,0,INDEX($B$1:$B$4,COUNTIF($B$1:$B$4,"<>0")))
again though assuming 0 to never be valid
Last edited by DonkeyOte; 12-15-2009 at 10:02 AM. Reason: forgot the IF
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks