Hey all,
Trying to figure out why my rule within conditional formatting is not matching exact. ID "000034" is highlighted in Column B, but is not in Column A. It is, however, contained within and ID of a cell. How do I achieve EXACT match? Using Excel Office 365 on iMac. Happens on my PC as well. Here is a link to my sample file: COUNTIF.xlsx
Select B2:B13 and use the formulaFormula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This doesn't work either. I used a greater than '0' in mine and neither way works.
This doesn't work either. I used a greater than '0' in mine and neither way works.Originally Posted by TMS
Select B2:B13 and use the formulaFormula:Please Login or Register to view this content.
I don't understand why that is happening. Use:Formula:Please Login or Register to view this content.
Either way should work. If I check in a cell, it counts 1 even though there are several cells which contain that ID.
These all contain the ID 000034, but yet the count is 1, even though it should be 0.
600003451
01-00000344-00-8
620000034403
1000034276202601485
1000034276205551596
0000000000345009-5
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks