blank rows

[greg]

Excel 2000

I have sections of data I want to seperate with a blank
row. There are 9 columns, with 6 different sections.

Each section will have anywhere from 3 to 10 rows of
data, not to exceed 10.

example of what I want:

col. a col. b
john pittsburgh
bill pittsburgh
kevin pittsburgh
(blank row)
dave chicago
terry chicago
(blank row)
fred boston
mary boston
shawn boston
mark boston
(blank row)
karen miami
john miami

Is there a way of using a countif with the row()
functions to make this happen?

thank you
greg malenky

 

[ray]

Hi Greg,
Sort your list by column B Then go to Data > SubTotals At
each change in B Use function Count Add subtotal to ??
Be carefull as Excel tends to pick columns for you
Good luck
Ray

 

[Guest]

Ray,

Will I have to used a conditional format to make the rows
blank?

Greg