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.