| 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Drag values down cells
Hi Mohd,
one way to do it is: imagine that your data are in column A, you could create a formula like this =if(left(a4,3)="PRJ";A4;B3) Copy it down, and copy the column be column A pasting special hope this helps Regards from Brazil Marcelo "mohd21uk via OfficeKB.com" escreveu: 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 |
| Reply |
| 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) | |||
Linear Mode
