hello, i am trying to get excel to display all values in Column B where Column F = 1
i know that an Array Formula will do this, i just have only used those one time and am not finding what i need on here.
i can use an index/match to get the first occurance, but when i make it an array and drag down it doesnt continue on to the next one...
anyone here who can help me that would be appreciated
i know that an Array Formula will do this, i just have only used those one time and am not finding what i need on here.
i can use an index/match to get the first occurance, but when i make it an array and drag down it doesnt continue on to the next one...
Code:
=INDEX(B:B,MATCH(1,F:F,0))
anyone here who can help me that would be appreciated