View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

Use a helper column with this formula copied down, then Copy Pastespecial
Values to get rid of the formula......then do your line-insertion based on

this column.....

=YEAR(A1)


Vaya con Dios,
Chuck, CABGx3


"Mpls501sMan" wrote in message
...
I have a file that I am trying to sort and add a line between years. This
file is 36,000 lines long and holds multiple records by a specific
identifyer. The problem is I have multiple records per year and I only

want
the file to put a break after each year not each date.

Please help! :-)

Thanks in advance