Hello,
I have a table, something like:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]Ben[/TD]
[TD]Blue[/TD]
[/TR]
[TR]
[TD]Charlie[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]White[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]Ben[/TD]
[TD]Blue[/TD]
[/TR]
[TR]
[TD]Charlie[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]White[/TD]
[/TR]
</tbody>[/TABLE]
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?