Having trouble explaining the thing I need to happen
Here's an example of what I need:
Four employees each like different cuisines for lunch. Based on who comes into the office, I would like each cuisine to sort by if the employees both like that cuisine, it returns ONLY the lines for which all selected employees choose the cuisine.
So if INPUT = "Alison" and "John", I would like the only output to be:
I was using this
=FILTER(A1:B9,("Alison"=B2:B10)+("John"=B2:B10))
But this returns all options for both Alison and John, instead I'd like to compare the two outputs and only return values that overlap.
I hope this makes sense...
Here's an example of what I need:
| A | B |
|---|---|
| Mexican | Alison |
| Mexican | David |
| Greek | John |
| Greek | Sam |
| Greek | David |
| Chinese | Alison |
| Chinese | John |
| Italian | Sam |
| Italian | John |
Four employees each like different cuisines for lunch. Based on who comes into the office, I would like each cuisine to sort by if the employees both like that cuisine, it returns ONLY the lines for which all selected employees choose the cuisine.
So if INPUT = "Alison" and "John", I would like the only output to be:
| Chinese | Alison |
| Chinese | John |
I was using this
=FILTER(A1:B9,("Alison"=B2:B10)+("John"=B2:B10))
But this returns all options for both Alison and John, instead I'd like to compare the two outputs and only return values that overlap.
I hope this makes sense...
