Loading...

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

19,489 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Mar 5, 2011

Download file: https://people.highline.edu/mgirvin/E...
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.

Loading...


to add this to Watch Later

Add to

Loading playlists...