» 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:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Learn MS Excel 2002 VBA/XML Programming
- Investing for Dummies, Third Edition
- Positioning: The Battle for Your Mind
- The One Page Business Plan: Start With a Vision, Build a Company!
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
No comments have been submitted.
