Hi all,
Just wondering how to get rid of the subtotal function to group the blank
column with the last grouped record... thank you

Replace the blanks with the same key value as the last group.

If you want you could use format|Conditional formatting to make it look like the
cells are still empty (white font on white fill).

If you want to try, visit Debra Dalgleish's site:
http://contextures.com/xlCondFormat03.html#Duplicate

Wally wrote:

Hi all,
Just wondering how to get rid of the subtotal function to group the blank
column with the last grouped record... thank you

--

Dave Peterson