Perhaps you can check whether the value you are looking for exists in the range, and if so display yes? So something like
=IF(COUNTIF(B2:B3000,"x")>0,"yes","no")
Perhaps you can check whether the value you are looking for exists in the range, and if so display yes? So something like
=IF(COUNTIF(B2:B3000,"x")>0,"yes","no")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks