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
37030 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
- Individual Income Tax Return Filing Due Dates for FY 2025-26 (AY 2026-27)
- New Column in ITR For AY 2026-27: "Receipts Not in Nature of Income" - What Is It?
- Section 44ADA of the Income Tax Act: Latest Rules and Questions Every Professional Asks
- PNB FD Interest Rates 2026 for 444 days: Maximize Your Returns Without a Long Lock-In
- AIS Income Tax Transactions: What to Report and What to Skip in AY 2026-27?
- Pensioner ITR for AY 2026-27: Guide to Reporting Pension Income and Claiming Your Tax Refund
- Income Tax Demand Notice 143(1): Know Why You Received It and What to Do Next?
- ITR Processing Time 2026: Know How Long Will It Take and What Each Status Message Means
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
