Using Excel I want to find data which MATCHes EXACT values within columns. Then I want the resulting values to be automatically TRIMmed so I can use them further without worrying about the format. My data consists of four columns - sequence / values1 / values2 / result (being the formula) This is it when the formula column is added
|
So, using the above table and formula, the result is thus |
A | B | C | D | |
---|---|---|---|---|
1 | 1 | one | one | TRUE |
2 | 2 | two | two | TRUE |
3 | 3 | three | three | TRUE |
4 | 4 | four | for | FALSE |
5 | 5 | five | five | TRUE |
6 | 6 | six | six | TRUE |
7 | 7 | oneone | oneone | TRUE |
8 | 8 | twotwo | twoten | FALSE |
9 | 9 | threethree | threethree | TRUE |
10 | 10 | fourfour | fourseven | FALSE |
11 | 11 | fivefive | fivefive | TRUE |
12 | 12 | sixsix | sixsixty | FALSE |