I'm having issues counting matches between 2 columns. Both of the columns dynamically shorten, so there are blanks at the end.
Here's the code I'm using:
If one column has blanks at the end, it works fine. If both have blanks, it's counting the blanks as matches. I'm struggling with how to include an AND statement that excludes "" or blank values. Any help?Please Login or Register to view this content.
Bookmarks