A | B | C | D | E | F | |
1 | 258 AA | Apple | 147 AA | Orange | 189 BB | Apple |
2 | 1 | 2 | 3 | 4 | 5 | 6 |
3 | 236 AA | Grapes | 151 BB | Pear | 189 BB | Apple |
4 | 2 | 8 | 4 | 7 | 6 | 1 |
5 | 258 AA | Apple | 486 BB | Grape | 147 AA | Orange |
6 | 5 | 6 | 8 | 2 | 7 | 9 |
7 | ||||||
8 |
Means the formula result must be 3
Totals cells evaluated = 9, Cells that ends with "AA" = 5, In that 258 AA (A1 & A5) and 147 AA (C1 & E3) is repeated twice, which has to be counted only once. so the result is 3.
Can any one help me in writing such a formula. I tried different methods but none worked.
Thanks in advance.