Hi Experts,
I would like to count set of comma separated values from another table.
For example, AF17=2,0,2 so i want to check/count this paired/set value within another paired/joined columns of 3,4,7=AD17.
The below mentioned formula is working fine if there is a single value in column AD & AF, but i need a formula to get the results based on a comma separated range & pairs please.
I have attached the sample file. Thanks in advance.Please Login or Register to view this content.
Bookmarks