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