Insert Row

[mizunobill]

I am just learning Excel is there a way to have a line insert automatically when a condition is met?

For example if I have column that has account numbers entered it, I would like to have a row inserted when the account number changes.

Acct #
225
225
225
226 Since this changes I want a line inserted??

Thanks if you can help!!

 

[Juan Pablo González]

There's nothing automatic that does that, but you can follow the following steps, assuming your data is in column A (with the header in A1)

1. In B2 enter the following formula:

=IF(A2<>A1,1,"")

2. Drag it down until the last cell in A where you have data.

3. Select column B, by clicking on the header.

4. Press F5, click on "Special", then select "Formulas" and "Numbers", and press Ok.

5. Press Control and the "+" key to bring up the "Insert" dialog.

6. Select "Entire Row" and click OK.

And you're done... you can now delete column B if you want.