AliGW
Administrator
- Joined
- Nov 8, 2015
- Messages
- 1,846
- Reaction score
- 8
- Points
- 38
- Location
- Ipswich, Suffolk, England
- Excel Version(s)
- MS 365 (Beta Insider Channel)
OK - so I had a look. Guess what? It's EXACTLY what I said it might be back in post #30 that YOU said you'd checked, but clearly not!!!
There are trailing spaces in the following cells on the COMPARE tab: B12, A37, A40, A42, A49 and A54. Get rid of them and the formula will work fine.
There are trailing spaces in the following cells on the COMPARE tab: B12, A37, A40, A42, A49 and A54. Get rid of them and the formula will work fine.