Quote:
Originally Posted by absthechatter
Is anyone able to help on this ...
|
As far as I can see this cannot be done using a worksheet formula. I'm sure a VBA macro could do it - would you be happy running code?
Alternatively, if this is a "one-off", there might be a workaround using copy, sort, paste, and a simple formula.
Over to you...