GVN KUMAR Member May 13, 2018 #1 sir all employees pan number for 1-4-17 to 31-3-18 in A column only march month pan number holders in B column how to find /getting A column non pan number employees list compare with march month employees list column B Attachments PAN SAMPLE LINGA.xls 31.5 KB · Views: 9
sir all employees pan number for 1-4-17 to 31-3-18 in A column only march month pan number holders in B column how to find /getting A column non pan number employees list compare with march month employees list column B
shrivallabha Excel Ninja May 13, 2018 #2 In cell C4 put following formula and copy down. =IF(ISNA(MATCH(A4,B:B,0)),"Non March","March")
GVN KUMAR Member May 13, 2018 #4 fast replay sir thank you sir a lot of thank you sir srivallabha sir
