Hello, i did this once but i forgot what i google'd.
I have a column that has vlookup and If statements that outputs 1 value, i need to embed an array formula to count the range to check if the number of outputs is met then stop the formula from outputting and leave it blank.
For example, see attached file.
C6 = Apples
C7 = 10 ( if count is 10 apples in column C14:C300 then stop count)
in C14 to C300 i use formulas to output Apple if certain criteria is met, if not met it can be blank or other values. The goal is once 10 apple values are found in that range the formula will output "BLANK" there after.
thanks for viewing this and any advise is appreciated.
Yong
Bookmarks