|
In response to
"7 -- Choose may be a better option for you. -- nm"
by
Fuzzy (mobile)
|
not familiar with CHOOSE. here's what I ended up with
|
=IF(OR($H4=$J4, $H4=$K4),IF($H4>$A$1, IF(COUNTIF('Gatekeeping Log'!E:E, $B4)>4,4,COUNTIF('Gatekeeping Log'!E:E, $B4))-1, IF(COUNTIF('Gatekeeping Log'!E:E, $B4)>4,4,COUNTIF('Gatekeeping Log'!E:E, $B4)))+1,IF($H4>$A$1, IF(COUNTIF('Gatekeeping Log'!E:E, $B4)>4,4,COUNTIF('Gatekeeping Log'!E:E, $B4))-1, IF(COUNTIF('Gatekeeping Log'!E:E, $B4)>4,4,COUNTIF('Gatekeeping Log'!E:E, $B4))))
|
Responses:
|