| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Insert Row
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Insert Row
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) -- If this helps, please click the Yes button Cheers, Shane Devenshire "marc" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
| insert row / insert column command buttons | Excel Worksheet Functions | |||
| How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
| Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) | |||
Hybrid Mode
