I need a formula To Count how many strings are before any reference located (PV2:PZ2)
I tried to find the right formula but no luck
Example :
PU5:QR5 Have 0 match on First 5 string that not match any of the 5 reference (PV2:PZ2)
PU7:QR7 Have 0 match on First 2 string that not match any of the 5 reference (PV2:PZ2)
PU10:QR10 Have 0 match on First 9 string that not match any of the 5 reference (PV2:PZ2)
Col_____PQ______________________pu_pv_pw_px_py_pz_qa_qb_qc_qd_qe_qf_qg_qi_qq_qr
Row
2____________________Reference-->___06_12_15_18_19
5____0 on first 5____________ColNam_16_13_10_11_24_06_05_04_09_08_07_12_02_15_14
7____0 on first 2____________ColNam_17_21_12_04_05_06_11_08_10_08_07_15_13_14_02
10___0 on first 9____________ColNam_01_25_23_04_05_22_07_08_09_06_11_13_18_14_16
Thank you so much
Bookmarks