MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sorting by format


Posted by lucas on September 20, 2001 5:11 AM

I need to make a sort in a long list in Excel and the only differential aspect is the format of the cell. Does anyone know a trick for this?


Posted by IML on September 20, 2001 7:58 AM

You might try adding another column with the formula
=CELL("format",A1)
and sorting by that, then deleting it. If "format" doesn't work, have a look at the CELL in the help file, depending on your formats, "prefix" or "type" may work as the first argument.

good luck