Excel Forum

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.