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
- Government's New e-Aadhaar App in 2025: You Can Now Edit Details from Home
- Section 87A Tax Rebate Allowed on STCG in New Tax Regime - Relief for Salaried Taxpayers
- Bank Transactions That Can Trigger an Income Tax Notice
- Co-Operative societies are liable to deduct tax from payment of interest
- Glitch in the System or Habitual Delay: Who's Really to Blame for ITR Filing Chaos?
- New GST Registration System from Nov: What Changes for Small Businesses
- Last Call for Tax Compliance - File Now or Face the Consequences
- Major Update in GSTR-9 Table 8A for FY 2024-25: ITC Reconciliation Logic Changed
Trending Online Classes
-
LIVE Course on GSTR-9 & GSTR-9C (Technical | Practical | Concept - Based)
Sachin Jain03 November 2025
CAclubindia
