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
|