Sort data witth blank line between entries - how?

  • Thread starter Martin ©¿©¬ martin
  • Start date
M

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
©¿©¬
 
F

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
 
D

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="")
 
M

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="")
Click to expand...

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
©¿©¬
 
M

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
Click to expand...

Thanks Frank
That was simple to do and worked well

Martin
©¿©¬
 
Top