Numerical sorting a group of data?

Please post a sample workbook with some typical data and formula, indicating what you need to achieve. If, for example, you use LEFT, MID and/or RIGHT to concatenate elements into a "number", that "number" will actually be text that looks like a number. You can use a double negative to coerce that text number into a true number, or multiply the value by 1 (one), or add 0 (zero) to it.

That should give you a numeric value that you can sort on.


Regards, TMS

I think you have a problem. The formula depends on values in column H which, in this case, are "hidden" using formatting. Each formula relates to four cells, one above the row, one on the row, and two below the row.

Can't see how you can possibly sort data structured like this.

Sorry.

If each formula related to data on its own row, that wouldn't be a problem. But I don't know what the process is for populating those cells. It's an unusual setup.