Articles by CA ROSHAN TIWARI
View Full Profile
Identify duplicate names in data base using vlookup in excel
CA ROSHAN TIWARI 24 February 2014 at 10:26SAMPLE DATA IS GIVEN BELOW :WRITE THE NAME YOU WANT TO CHECK FOR DUPLICATE ENTRY IN CELL C4 AS SHOWN BELOW :WRITE THE FORMULA IN CELL D7 & COPY IT FOR CELL ADDRESS AS SHOWN BELOW :WRITE THE FORMULA OF VLOOKUP IN CELL D4 AS SHOWN BELOW :IF THE N
Popular Articles
- Latest Changes in ITR Forms for AY 2025-26
- Section 143(2) Income Tax Notice for AY 2024-25: Scrutiny Assessment, Faceless Process & Deadlines Explained
- How Unnecessary UPI Transactions Can Trigger Tax Notices?
- Compulsory Maintenance of Accounts - Section 44AA
- Are Co-operative Societies Liable Under GST?
- CA Day 2025: Fascinating Facts Every Chartered Accountant and Aspiring CA Should Know!
- Tax Rules for Freelancers in FY 2025-26: ITR Filing, TDS and GST Compliance
- Key important changes in GST Return one should know
Trending Online Classes
CAclubindia
