| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drag values down cells
I have a column in a spreadsheet with values listed below
PRJ WBS-025554 WBS-031150 WBS-121351 WBS-155455 PRJ WBS-025555 WBS-0151415 WBS-0215454 I would like to drag all the values that start with PRJ until the next PRJ is reached. I have illustrated this below: PRJ WBS-025554 PRJ WBS-025554 PRJ WBS-025554 PRJ WBS-025554 PRJ WBS-025555 PRJ WBS-025555 Many Thanks in advance. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200606/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum up values only in cells that are color filled? | Excel Worksheet Functions | |||
| Counting Cells with certain date ranges as values | Excel Worksheet Functions | |||
| How do I define a range using values in cells? | Excel Worksheet Functions | |||
| cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
| Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
Threaded Mode
