I have a table of yellow cells which contain different questions candidates have struggled with and require help on.
I would like to populate the blue table quickly by using a formula that counts how many times the blue questions appear in the yellow list.
As you can see from the formula I have tried to use, my problem is with the wildcard. When it tries to count the number of times "1" appears in the yellow cells it ends up counting other values of the 1 appearing in other cells, possibly those written as a 10, 11, 12 etc.
Qns.PNG
I would rather avoid splitting the yellow cell text into columns at all costs.
Any help would be greatly appreciated!
Thank you.
Bookmarks