Cleaning Duplicate Rows in Excel
CONCATENATE, sort and IF statements find duplicates while keeping an audit trail.
Mithun A. Sridharan
I'm Mithun A. Sridharan, Founder of this website - Think Insights - on Strategy, Management Consulting, Leadership, Digital Transformation, and Data Literacy. Follow me on social media or connect with me on LinkedIn for updates.
1183
Articles
November 2024
Member since
Articles by Mithun A. Sridharan
Reading the Elephant Chart
One chart explains globalization's winners, losers and the politics they produced.
Balanced Scorecard (BSC)
The Balanced Scorecard (BSC) is a strategy execution framework that links vision & strategy to actionable initiatives
Writing a Strategy Paper
A step-by-step guide to researching, structuring and writing concise strategic advice.
Customer Journey Maps
Customer Journey Maps are structured, collaborative tools to linearly map the experience of your customers & strategically develop those experiences
Why McKinsey Stays in the News
Praise, scandal and skepticism all orbit McKinsey without denting demand.
Strategy Lessons From Executives
Six executive strategy questions answered with frameworks, trade-offs and actionable advice.
MBTI Personality Assessment
MBTI is an assessment tool that helps individuals and organizations understand personalities and optimize workplace dynamics
Human-First Thought Leadership
Why more credible executive thought leadership starts with lived decisions, observed tensions and practical lessons rather than recycled trend commentary
Work Smart and Lazy
Strategic consultants grind hard, then focus on outcomes that compound over time.
Pros And Cons Approach
The pros-and-cons list is a proven decision-making approach using a simple sheet of paper or Excel document with just two columns
Cornell Note Taking Method
The Cornell Method is a note-taking method that has proved itself, both efficient and superior to other techniques
Cleaning Duplicate Rows in Excel
CONCATENATE, sort and IF statements find duplicates while keeping an audit trail.
Reading the Elephant Chart
One chart explains globalization's winners, losers and the politics they produced.
Balanced Scorecard (BSC)
The Balanced Scorecard (BSC) is a strategy execution framework that links vision & strategy to actionable initiatives
Writing a Strategy Paper
A step-by-step guide to researching, structuring and writing concise strategic advice.
Customer Journey Maps
Customer Journey Maps are structured, collaborative tools to linearly map the experience of your customers & strategically develop those experiences
Why McKinsey Stays in the News
Praise, scandal and skepticism all orbit McKinsey without denting demand.
Strategy Lessons From Executives
Six executive strategy questions answered with frameworks, trade-offs and actionable advice.
MBTI Personality Assessment
MBTI is an assessment tool that helps individuals and organizations understand personalities and optimize workplace dynamics
Human-First Thought Leadership
Why more credible executive thought leadership starts with lived decisions, observed tensions and practical lessons rather than recycled trend commentary
Work Smart and Lazy
Strategic consultants grind hard, then focus on outcomes that compound over time.
Pros And Cons Approach
The pros-and-cons list is a proven decision-making approach using a simple sheet of paper or Excel document with just two columns
Cornell Note Taking Method
The Cornell Method is a note-taking method that has proved itself, both efficient and superior to other techniques