Formula help

  • Thread starter Thread starter SlicK the original
  • Start date Start date
S

SlicK the original

I receive 3 excel sheets each week with a list of cars on them.
The data has to be merged into one document.
The data then needs to be then sorted into car manufacturer, then models,
then price(descending).
I can do the first two using DATA/SORT, but it will not work when I try to
do the third(which is price)

2002 02 Fiat Punto Active 5dr Met Steel Grey £4995
2003 53 Alfa Romeo 147 1.6 TS Lusso 3dr Met Gabianno £11995
2003 53 Ford Mondeo Zetec 1.8 3dr Metallic Black £5995

Any help would be appreciated.
I can email the before and after excel file if you wish.

SlicK
 
The figures in the price col (4995,11995,5995) could be text

Assuming the price figs are in col D, D2 downwards

In an adjacent col, say col E

put in E2: = VALUE(D2)
(this will convert the text in col D to numbers)

Copy E2 down col E

Then use col E as the 3rd sort col
[as proxy for col D]
 
Back
Top