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 for...
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...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...

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.