» Find the most commonly repeated string in a column in Microsoft Excel
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
In cells A1:A14, the following values appear
Enter the following formula in cell B1: =COUNTIF(A:A,A1) - copy the formula from cell B1 to B2:B14
The result:
Enter the following formula in cell C1: =INDIRECT(ADDRESS(MATCH(MAX(B:B),B:B,0),COLUMN(A:A)))
The Result: AAA
Enter the following formula in cell D1: =MODE(B1:B14)
The Result: 5
Book Store:
Recommended Books:
- Marketing Plan: A Handbook with Marketing Plan
- Financial Statement Analysis with S&P insert card
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Wall Street Journal Guide to Understanding Money and Investing
- Marketing Plans That Work, Targeting Growth and Profitability
- The One Page Business Plan: Start With a Vision, Build a Company!
No comments have been submitted.
