I am using a formula for Data Validation to hide used names like this: =IF(COUNTIF(DrawUsed, [Players])>=1, "", [Players])
, where DrawUsed
is a named range. The problem is that my table looks like this:
I need the Blind Draw Team
columns to be the first parameter of the COUNTIF
, since if a name is used in the first column, it should not be available for the third Blind Draw Team
column. The issue is that this formula, with a named range defined =Blind!$B$2:$B$27,Blind!$I$2:$I$27,Blind!$P$2:$P$27
results in nothing but #VALUE!
errors.
I cannot define a contiguous range because the Buyer
columns should not be dependent on the values of Blind Draw Team
, and should not hide used names, either.
Does anyone have any advice?