|
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 |
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 |
| All times are GMT +1. The time now is 05:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com