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.