Hi Experts,
I Have two column Data-1 & Data-2,here i want to know how many No. or text of data-2 is match with data-1 as shown in result column.Please tell me a formula other than V-lookup.I know there is some Count formula but unable to use.
DATA-1 DATA-2 Result
33 66
A 33 Yes
SE 1
B D
55 C Yes
YY A Yes
C SS
UU D
Karan
I Have two column Data-1 & Data-2,here i want to know how many No. or text of data-2 is match with data-1 as shown in result column.Please tell me a formula other than V-lookup.I know there is some Count formula but unable to use.
DATA-1 DATA-2 Result
33 66
A 33 Yes
SE 1
B D
55 C Yes
YY A Yes
C SS
UU D
Karan
Last edited:
