Extracting Unique, Duplicate and Missing Items using Formula
CA Kumar Mukesh
Author
File details
File description
Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates, makings lists unique, find missing items, remove spaces etc. Alas, instead they have provided features like clippy which are intrusive to say the least.
So as part of our second installment of spreadcheats we will learn how to tackle few of the most common data processing tasks: #xls
Comments
Recent Files in Technology & Tools
View more →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
Popular Files
- ICAI Suggestions on GST Registration & Refund Processes
- ICAI E-Way Bill Handbook - Aug 2026 Edition
- Processing Status of Citizen’s Charter Applications as of Sept 30, 2026
- RBI Bulletin - September 2026
- RBI | Report of the Advisory Committee on Ways and Means Advances to State Govts
- Monthly Economic Review - Sept 2026
- ICSI | Exposure Draft of Proposed Syllabus 2027
- ICAI Students' Journal: October 2026 Edition
CAclubindia
