Sort data witth blank line between entries - how?

[Martin ©¿©¬ martin]

Hi
I have a worksheet with data entries
These consist of 1,2,3,4 or more consecutive/grouped entries with the
same name in column b for each entry, then a blank line between the
next consecutive/grouped entries and so on ....
Each group of entries has a box border, which i would like to keep if
possible.

How do i sort column b alphabetically?

The only way i can get *sort* to work is to remove the space between
my grouped entries

Martin
©¿©¬

 

[Frank Kabel]

Hi
just for sorting you may use a helper column. Lets say you use column D
for this and row 1 is a header row. Enter the following in D2:
=IF(B2="",B1,B2)
and copy this down for all rows.
Now you can sort with this helper column

 

[Debra Dalgleish]

To sort the list, add the name in column b for the blank rows, then hide
the name in the blank rows with conditional formatting. There are
instructions here for filling the blanks, and there's code to automate
the process, if it's something you do frequently.

http://www.contextures.com/xlDataEntry02.html

To hide the name in the blank rows, you can use conditional formatting:

http://www.contextures.com/xlCondFormat03.html#Duplicate

For your worksheet, change the conditional formatting formula to:
=AND(B2=B1,C2="")

 

[Martin ©¿©¬ martin]

To sort the list, add the name in column b for the blank rows, then hide
the name in the blank rows with conditional formatting. There are
instructions here for filling the blanks, and there's code to automate
the process, if it's something you do frequently.

http://www.contextures.com/xlDataEntry02.html

To hide the name in the blank rows, you can use conditional formatting:

http://www.contextures.com/xlCondFormat03.html#Duplicate

For your worksheet, change the conditional formatting formula to:
=AND(B2=B1,C2="")

Thanks Debra
I'll keep your info for future reference, though I did use Frank's
method first, which worked fine, so i haven't tried your method as
yet.

Martin
©¿©¬

 

[Martin ©¿©¬ martin]

Hi
just for sorting you may use a helper column. Lets say you use column D
for this and row 1 is a header row. Enter the following in D2:
=IF(B2="",B1,B2)
and copy this down for all rows.
Now you can sort with this helper column

Thanks Frank
That was simple to do and worked well

Martin
©¿©¬