View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Inserting a blank line

I have a column sorted by cities and a column next to that with the numbers
that can be 5, 10, 15, 25 or 30. I need to insert a space between cities and
have a count how many 5s, 10s, 15s etc there are.

column A: column D:
Boston 30
Boston 15
Boston 5
Boston 15

(in column D) 5 1(in column E)
15 2
30 1

Detroit 10

10 1

Orlando 10
Orlando 10
Orlando 10

10 3