| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting the same value until the same value is reached again
I have some imported data that has a row which states the branch name at the
start of the data and again at the end, the data then changes branch and the same thing happens. see example company2030 GroupSales InternalDirectSale Retail Trade W/SExternal W/SInternal W/SWarranty ZSurcharges company2030 branch branchmbch company3030 B/SExternal B/SWarranty GroupSales InternalDirectSale Retail Trade W/SExternal W/SInternal W/SWarranty ZSurcharges company3030 branchmb branchmbco Want i need to happen is, in the column to the left of the data between the same company number is the company number addedis the company number along side the data between the same company numbers. I hope this makes sense |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting the same value until the same value is reached again
OK, I will try and make some sense
If the data appears in column B, I would like to insert the company name in colum A on all data between the same 2 company numbers. The 2 lines of data in between the company change can be ignored. "Dave F" wrote: Doesn't make sense, sorry. -- Brevity is the soul of wit. "Scrum Down" wrote: I have some imported data that has a row which states the branch name at the start of the data and again at the end, the data then changes branch and the same thing happens. see example company2030 GroupSales InternalDirectSale Retail Trade W/SExternal W/SInternal W/SWarranty ZSurcharges company2030 branch branchmbch company3030 B/SExternal B/SWarranty GroupSales InternalDirectSale Retail Trade W/SExternal W/SInternal W/SWarranty ZSurcharges company3030 branchmb branchmbco Want i need to happen is, in the column to the left of the data between the same company number is the company number addedis the company number along side the data between the same company numbers. I hope this makes sense |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting the same value until the same value is reached again | Excel Discussion (Misc queries) | |||
| Inserting rows between each entry | Excel Discussion (Misc queries) | |||
| inserting rows in linked worksheets | Excel Discussion (Misc queries) | |||
| Separate Groups by Inserting Lines | Excel Discussion (Misc queries) | |||
| Inserting Footer - Ajit | Excel Discussion (Misc queries) | |||
Linear Mode
