Good day, everyone!
This site has been very handy the last few days, but I'm stumped now and no matter how I search, I can't find the answer ...
I have two columns that I want to compare (F and K).
The data in each is not numerical --- one is a date (K), the other is plain text (F). What I need to do is compare each cell in those columns, and if column F has a date in the same row as Column K, I want it to count as "1".
Then I need to have the total sum of these cells with dates returned to me in a new worksheet.
I have a hokey solution for this now involving "ISBLANK" arguments for each row, but ... that's too messy.
If you feel like helping me tackle this, please do!![]()
Thank you all kindly for making this site so helpful in general!
- PL
Bookmarks