Jan 16 2023 01:51 PM
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.
Jan 16 2023 02:13 PM
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"), "")