Formula to add rows if cell 2,1 doesn't match 3,1

Hi, I would like to write a formula that will insert a blank row every time a cell doesn't match the cell directly above it. Basically I have a list of people who may have multiple rows of data each. I want this formula to add a row between each person.

For example:
Sue Smith
Sue Smith
Sue Smith...add row
Tom Jones...add row
Sally Mae
Sally Mae
Sally Mae
Sally Mae..add Row
Tammy T
.......


I want this formula/if statement to identify the breaks and add a blank row.


Any tips? Seems so simple but I can't make it happen.

I can only think of a macro if you want excel to insert blank. I didn't know any formula that allow excel to insert row/column.

Hi, I'm actually writing a macro. I first was trying it as a loop and that didn't work and then I tried to insert rows after an If statement. I also did a quick if statement to bring back each break in the cells and then tried to insert from there. No luck.

VBA code would be ideal

Any tips? Seems so simple but I can't make it happen.[/QUOTE]

Try Data > Subtotal > I will let you figure out the rest. If you have any problems post back.

assuming your talking about inserting a space in a list that is generated on another worksheet see columns A of the two sheets of this workbook....
spaced names.xlsx

If you want to automatically insert it on the same sheet the other users are correct, you will need to do some VBA.

I didn't see that you were trying to do this with code. I don't have time to work out the code but if I did I would create a two dimensional array that stores the name with a row number. so NameList(1,1) would be 1 - NameList (1,2) would be "Sue Smith". Namelist(2,1) would equal namelist(1,1)+1 . when it came to Tom jones I would have Name List(4,1)=name List(3,1)+2
then i would rewrite everything with cell(namelist(1,1),1)=namelist(1,2)

Simple code

Please Login or Register  to view this content.