Articles by CA ROSHAN TIWARI
View Full Profile
Identify duplicate names in data base using vlookup in excel
Posted by CA ROSHAN TIWARI
01 August 2020
37074 Views
SAMPLE 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
- Post Office Schemes Investment Strategy 2026: Know How To Generate Rs 52,000 Monthly?
- Form 3CD Tax Audit Due Date Extension AY 2026-27: Critical Compliance Guide
- GSTR-9 Applicability for FY 2025-26: Who Must File and Who Is Exempt?
- Belated Return Due Date for AY 2026-27: Check Deadline and Penalty
- MCA Corporate Law Reforms 2025: Major Changes in Small Company Limits, Director KYC and Fast-Track Mergers
- TDS on Rent After the Rs 50,000-a-Month Rule: 7 Worked Cases for 2026
- GST Changes from 1st Nov 2026: New Rules for Post-Supply Discounts
- Form 3CD Tax Audit Changes AY 2026-27: Critical Updates & Compliance Guide
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
