MrExcel Publishing
Your One Stop for Excel Tips & Solutions

DATE SPACE


Posted by MARK on July 06, 2001 11:20 PM

I HAVE A LIST OF INFORMATION THAT IS SORTED INTO DATE ORDER,WHAT I WOULD LIKE TO DO NOW IS INSERT A BLANK LINE BETWEEN DIFFRENT BLOCKS OF DATES IS THIS POSSIBLE?

THANKS IN ADVANCE
MARK


Posted by cpod on July 07, 2001 6:33 AM

If your date data starts in cell A2 then ,in a blank column, starting in the third row, enter this formula and copy down:

=IF(A3=A2,1,"x")

This should place an X in each cell corresponding to a new date in your date column and a 1 in the all the other cells.

Then go to:

Edit-> Goto -> Special -> Formulas

and uncheck everything but "Text".

This should select all the X's. Then, with the X's selected, go to: Insert -> Row