CountIf Error

grt2bsec

New member
Joined
Jan 22, 2019
Messages
2
Reaction score
0
Points
0
Location
Asheville, NC USA
Excel Version(s)
Office 365
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.
 

Attachments

  • 01.22.19 share.xlsx
    61.4 KB · Views: 13

Fluff

Member
Joined
Sep 9, 2018
Messages
136
Reaction score
0
Points
16
Excel Version(s)
O365
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
 

Fluff

Member
Joined
Sep 9, 2018
Messages
136
Reaction score
0
Points
16
Excel Version(s)
O365
You're welcome & thanks for the feedback
 
Top