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

Select column A and F5SpecialBlanksOK

EditDeleteentire RowOK

Select column B and F5SpecialBlanksOK

Type an = sign in active blank cell.

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

Select column B

CopyPaste Special(in place)ValuesOKEsc.

Sort on column B


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 17:52:57 +0200, "Jack Sons" wrote:

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

Marvellous, thank you Gord.

Jack.

"Gord Dibben" <gorddibbATshawDOTca schreef in bericht
...
Select column A and F5SpecialBlanksOK

EditDeleteentire RowOK

Select column B and F5SpecialBlanksOK

Type an = sign in active blank cell.

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

Select column B

CopyPaste Special(in place)ValuesOKEsc.

Sort on column B


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 17:52:57 +0200, "Jack Sons" wrote:

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

Glad to help.

Thanks for the feedback.



On Thu, 19 Jun 2008 23:31:59 +0200, "Jack Sons" wrote:

Marvellous, thank you Gord.

Jack.

"Gord Dibben" <gorddibbATshawDOTca schreef in bericht
.. .
Select column A and F5SpecialBlanksOK

EditDeleteentire RowOK

Select column B and F5SpecialBlanksOK

Type an = sign in active blank cell.

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

Select column B

CopyPaste Special(in place)ValuesOKEsc.

Sort on column B


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 17:52:57 +0200, "Jack Sons" wrote:

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