Hello,
I have a table, something like:
<tbody>
</tbody>
I want to use a list type validation in another range with the list values being where Column 2 = Orange, so the list would be:
Adam
Charlie
I've Created a named range for both _Column1 and _Column2 and tried the formula:
=COUNTIFS(_Column1,A2,_Column2,"Orange")
WHich doesn't work and I'm not sure where to go from there.
Am I even close?
I have a table, something like:
Column 1 | Column 2 |
Adam | Orange |
Ben | Blue |
Charlie | Orange |
David | White |
<tbody>
</tbody>
I want to use a list type validation in another range with the list values being where Column 2 = Orange, so the list would be:
Adam
Charlie
I've Created a named range for both _Column1 and _Column2 and tried the formula:
=COUNTIFS(_Column1,A2,_Column2,"Orange")
WHich doesn't work and I'm not sure where to go from there.
Am I even close?