I'm going to apologize right off the bat. I've never used VBA before but I have used the countifs formula so I'm not sure if I'm going about this the right way. I have an array that I want to count if the cell reference equals a specific name. However, if the name referenced has a strikethrough it, how do I exclude that in the count? I've found other wonderful experts who have shared countstrike or countnostrike codes, but that counts everything with a strike or no strike. My issue is I want to count a specific name in my array without the strike.
I hope that makes sense and if anyone has any insight, I'd appreciate the help. Thank you!
Bookmarks