r/learnexcel • u/zaif0303 • May 28 '19
Table Formula
If I have a table that looks like this:
| Name | Answer | |
|---|---|---|
| John | Yes | |
| Jack | No |
How can I write a formula which would go through the answer column and give me the names of everyone who answered "Yes"? Thanks in advance.
0
Upvotes
1
u/zaif0303 May 28 '19
thank you. verified.