Insert Row

[marc]

How can I insert a row anywhere a particular value shows in a cell

example b1:b50 contain a list of Names Bill,Bob,Phil

Anywhere bill appears I would like to insert a row break

thanks

marc

 

[Shane Devenshire]

Hi,

1. create a column with a formula like the following in a blank column (D2
form example)
=FIND("Bill",A2)
where A2 is the first cell you want to check
2. Copy this formula down
3. Select the column of formulas
4. Press F5, Special, Formulas and uncheck all but Numbers, OK
5. Press Ctrl Shift + (Ctrl Plus) and select Entire Row

If you want to insert the row below then change the formula in D2 to read
=FIND("Bill",A1)