xls

Remove duplicates & sort a list using Pivot Tables

  Download   Preview

today I want to show you a technique I have been using to dynamically extract and sort all unique items from a last list of values using Pivot Tables & OFFSET formula. #xls
CA Kumar Mukesh

on 02 April 2013

Other files by the user
1374 times
97 KB

Download Other files in Info Technology category


Share Report
Summarize this with AI
ChatGPT Perplexity Claude Google AI Grok

CCI Pro
Comments

CAclubindia's WhatsApp Groups Link


Trending Downloads

pdf
CBDT Introduces Draft Form No 28 for Net Worth Computation
On : 28 February 2026
Download
pdf
TDS/TCS Book Adjustment New Draft Format
On : 04 March 2026
Download
pdf
Draft Form 170: New Income Tax Valuation Rules
On : 27 February 2026
Download
pdf
Permanent Exemption Window (Intermediate & Final) - May 2026 CA Exams
On : 28 February 2026
Download
pdf
Draft Form No. 86: New Warrant of Authorisation Rules
On : 27 February 2026
Download
pdf
Fee Chart for May 2026 CA Exams
On : 28 February 2026
Download

view more



Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us


Popular Files


  1. Form 121: One Declaration for TDS Exemption
  2. Draft Form 141: New TDS Compliance Rules for Individuals and HUFs
  3. CBDT Introduces Draft Form No 28 for Net Worth Computation
  4. TDS/TCS Book Adjustment New Draft Format
  5. Draft Form 170: New Income Tax Valuation Rules
  6. Draft Form 104 Sets New Compliance Rules for NGOs
  7. Draft Form 165 Introduces Detailed SFT Reporting Framework
  8. Permanent Exemption Window (Intermediate & Final) - May 2026 CA Exams
  9. Draft Form No. 86: New Warrant of Authorisation Rules
  10. Fee Chart for May 2026 CA Exams