A
andy62
I need to modify this array-entered formula to not count blanks as zero. The
challenge seems to be that the cobination of INDIRECT() and N() is converting
blanks to zero.
{=MIN(N(INDIRECT("Rater" & ROW(1:4) & "!G"&$B$3)))}
In plain english, the function looks at the same cell (e.g., G7, when cell
B3 is set to 7) across 4 worksheets (Rater1 thru Rater4).
I don't need to first function to be MIN, it could be a COUNT. I just need
it to stop treating blanks as 0.
TIA
challenge seems to be that the cobination of INDIRECT() and N() is converting
blanks to zero.
{=MIN(N(INDIRECT("Rater" & ROW(1:4) & "!G"&$B$3)))}
In plain english, the function looks at the same cell (e.g., G7, when cell
B3 is set to 7) across 4 worksheets (Rater1 thru Rater4).
I don't need to first function to be MIN, it could be a COUNT. I just need
it to stop treating blanks as 0.
TIA