Hi Guys

I have the workbook which contains numbers in column C.

If i put any number to search in cell G6, then have to lookup in column C and count and sort based on their count from each workbook with their names as follows,

If i put 6077 in G6 then lookup and return result as follows

B 1 A 0

Here A, B is the workbook names and numbers (1, 0) are count of 6077 from each workbook

Please find the attached workbook and advise.

thanks
Ganesan. G

Attached Files

Excel function help.xlsx (11.1 KB, 9 views)