Don't have rights to attach any file. I wanted to add the sample file so can explain better what formula I want to apply. I'll try copy/paste the contents and explain the scenario to see if this works.
In the following data, I need to see how many times a particular number from Column G "List"...