Excel Forum
Similar Content
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the fo...
SORTBY() - New Excel 365 Function to Sort Data
Tutorial: Learn Excel's New Function to Sort Data! This is the SORTBY() function for Excel 365 and ...
Formula to Count Occurrences of a Word in a Cell or Range in Excel
Tutorial: Formula to count how many times a word appears in a single cell or an entire range in Exce...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data


Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to use the COUNTIF, INDEX, ROWS and comparative operators to sort a table of data with a formula. This solution will soret the word column but bring along the numbers from the same row. Trick from Andrew Poulsom at Mr Excel Message Board.





Got a Question? Ask it Here in the Forum.