PDA

View Full Version : CountIf Error



grt2bsec
2019-01-22, 02:30 PM
Hello and thank you in advance for any assistance you may have to offer. I've removed some proprietary information but have left the formula cells on the attached. The purpose of the sheet is to determine if the column D Coil_Num has appeared anywhere in the prior weeks lists of columns E through N. The CointIf function seemed to be accomplishing that, but I noticed the yellow highlighted cell is incorrect. I'm not sure if there are other inconsistencies but noted this one. The formula should have returned 1 for 1 prior instance.

Fluff
2019-01-22, 03:19 PM
If you are referring to M20, the value in that cell is 2326386 whereas the value in D10 is 2326386.001
Hence you get a count of 0

grt2bsec
2019-01-22, 03:27 PM
If you are referring to M20, the value in that cell is 2326386 whereas the value in D10 is 2326386.001
Hence you get a count of 0

Wow, I didn't consider that Thanks!

Fluff
2019-01-22, 03:35 PM
You're welcome & thanks for the feedback