sorting problem

[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

 

[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

 

[Jack Sons]

Marvellous, thank you Gord.

Jack.

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

 

[Gord Dibben]

Glad to help.

Thanks for the feedback.

Marvellous, thank you Gord.

Jack.