Insert Row

  • Thread starter Thread starter marc
  • Start date Start date
M

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
 
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)
 
Back
Top