sorting problem

J

Jack Sons

Hi all,

In column A I have the description of wines, 3 up to 6 lines per record. A
blank cell separates each record from the next one.
To the right of the first cell of the record (so in column B) is the price
in euros.

Example:

Etienne Sauzet "Perrières" 2003 (available per 1 bottle) 58,75
Puligny montrachet premier cru white
.... More Informations
1855 Notation:
Parker Notation: 89 / 100

Domaine Fontaine-Gagnard 2003 (available per 1 bottle) 35,27
Chassagne-montrachet white
.... More Informations

Domaine Fontaine-Gagnard 2003 (available per 1 bottle) 293,75
etc. etc.

Please notice the European notation with decimal comma in stead of decimal
point.

I want to sort the records by price but keep the order of the cells in each
record. How can I do this?

Jack Sons
The Netherlands

PS

For those who are interested, the examples come from www.1855.com
 
G

Gord Dibben

Select column A and F5>Special>Blanks>OK

Edit>Delete>entire Row>OK

Select column B and F5>Special>Blanks>OK

Type an = sign in active blank cell.

Point or arrow up to cell above and hit CTRL + ENTER to replicate.

Select column B

Copy>Paste Special(in place)>Values>OK>Esc.

Sort on column B


Gord Dibben MS Excel MVP
 
J

Jack Sons

Marvellous, thank you Gord.

Jack.

Gord Dibben said:
Select column A and F5>Special>Blanks>OK

Edit>Delete>entire Row>OK

Select column B and F5>Special>Blanks>OK

Type an = sign in active blank cell.

Point or arrow up to cell above and hit CTRL + ENTER to replicate.

Select column B

Copy>Paste Special(in place)>Values>OK>Esc.

Sort on column B


Gord Dibben MS Excel MVP
Click to expand...
 
Top