IF FORMULA

Occasional Visitor

Hi I have been using an IF formula but I cant figure out how I can get it return text from another cell.  example I have a list of names in column A and in columns B-F I have a yes or no next to the names and I want to create a formula to list all the names that have yes under each column. At the moment my formula has the individual name in it but I want to replace the name for the cell that the name is in incase my list of names change. Hopefully this makes sense and someone can help me.

1 Reply

@BETHGRANT2021 

If you have Microsoft 365 or Office 2021, enter the following formula in for example H1:

 

=FILTER(A1:A1000, (B1:B1000="Yes")*(C1:C1000="Yes")*(D1:D1000="Yes")*(E1:E1000="Yes")*(F1:F1000="Yes"), "")