View Single Post
 
Old 10-28-2016, 09:23 AM
scottyb scottyb is offline Windows 10 Office 2013
Novice
 
Join Date: Oct 2016
Posts: 1
scottyb is on a distinguished road
Default Increase number in cell, based on value in adjacent cell

I have a need to change a number of cells that in one column, but not one after the other, there are blanks, headers, and others bits of information that need to remain. The only cells I want to change have the same text in the column next to them, so I guess if I could get a formula that could change based on this label, I could achieve what I need. Example as below:-

So where it says Title 2, I want to increase the value in the cells in column L next to it 13%.

Any help much appreciated, as the data i have is well over 1500 lines.
Column K Column L
Title 1 176.30
Title 2 8.35
New Menu
Title 1 219.00
Title 2 23.90
New Page
Title 1 9.22


Maybe clearer in the image,

Reply With Quote