Good day!
Okay, so my last thread didn't seem realistic. So I decided to tackle on my problems 1 at a time and see if I can build on it from here.
We know how INDEX/MATCH works, and it's very nice. I attached a COUNTIF to it to count how many times the index finds itself on another table; if it doesn't find itself, then it goes blank. However, this time I need to count how many times it finds a certain string condition in the other table.
Am I making sense?
Here is a sample file which I hope will help:
sampleexcelhelp.xlsx
The columns that need to be filled are shaded in dark pink. Thank you!
Bookmarks