Andy D 2002
Board Regular
- Joined
- Apr 22, 2002
- Messages
- 106
Hi
Bit of a confusing one this..
I have 8 columns. In the 9th column i want to include a formula that compares the contents of the 8 cells to the left..if they are the same to say "same" if not the same to say "not the same"
Complication: if one of more of the cells says, say, "exclude" then the formuala should exclude these cells
Example using 4 columns (remember there are 8 on my sheet):
A 1 = ABC, B1 = ABC, C1 = ABC, D1 = ABC: E1 = "Same"
A 2 = ABC, B2 = ABC, C2 = ABC, D2 = EXCLUDE: E2 = "Same"
A 3 = ABC, B3 = ABC, C3 = ABCDEF, D3 = EXCLUDE: E1 = "Not Same"
Any help would be appreciated, thanks Andy
Bit of a confusing one this..
I have 8 columns. In the 9th column i want to include a formula that compares the contents of the 8 cells to the left..if they are the same to say "same" if not the same to say "not the same"
Complication: if one of more of the cells says, say, "exclude" then the formuala should exclude these cells
Example using 4 columns (remember there are 8 on my sheet):
A 1 = ABC, B1 = ABC, C1 = ABC, D1 = ABC: E1 = "Same"
A 2 = ABC, B2 = ABC, C2 = ABC, D2 = EXCLUDE: E2 = "Same"
A 3 = ABC, B3 = ABC, C3 = ABCDEF, D3 = EXCLUDE: E1 = "Not Same"
Any help would be appreciated, thanks Andy