Number count and sort macro

In column A and column C for the first 10 rows only I have data in a cell followed by a number (possibly two numbers sometimes separated by a comma) in the same cell. I want a macro to tell me the lowest number that it finds and the word it was found beside. I have attached a sample workbook showing a before and after.

samplesheet.xlsm

Any ideas? Perhaps something with Text to Columns might help but I still haven't found a good way yet.

Try this

Please Login or Register  to view this content.

Thanks Jindon. Works perfect if there is only one word. However at times the cell will be "Test Test 12" or a different number or perhaps "Test Test Test 12". Is there a way to deal with those possible differences in the macro? Thanks!

Need to see variety of data and the desired result from there.

Here you go.

Thanks again!

samplesheetNEW.xlsm

OK

Please Login or Register  to view this content.

Awesome! Thankks!