bbrimberry
New Member
- Joined
- Mar 23, 2016
- Messages
- 34
hey gang,
Im looking to compare multiple columns with a formula.
Im trying to put a formula in column K that would tell me if the cell values in column B thru column J are the same.
if B thru J are the same value or blank the formula should return Yes
if B thru J are different the formula should return No
I would like to ignore blanks.
Im looking to compare multiple columns with a formula.
Im trying to put a formula in column K that would tell me if the cell values in column B thru column J are the same.
if B thru J are the same value or blank the formula should return Yes
if B thru J are different the formula should return No
I would like to ignore blanks.
Book1.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Store | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9 | Match | ||
2 | 1 | James | James | James | James | James | Y | ||||||
3 | 2 | John | John | John | John | John | Michael | Michael | N | ||||
4 | 3 | Robert | Robert | Michael | N | ||||||||
5 | 4 | Michael | Michael | Michael | Michael | Michael | Y | ||||||
6 | 5 | Richard | Richard | Michael | Michael | N | |||||||
7 | 6 | Matthew | Matthew | Matthew | Anthony | Anthony | Anthony | N | |||||
Sheet1 |