Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-28-2016, 09:23 AM
scottyb scottyb is offline Increase number in cell, based on value in adjacent cell Windows 10 Increase number in cell, based on value in adjacent cell Office 2013
Novice
Increase number in cell, based on value in adjacent cell
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Increase number in cell, based on value in adjacent cell Need help with using traffic lights in one cell based on date value in a different cell wmedjaxnjr Excel 1 04-09-2016 04:22 PM
Increase number in cell, based on value in adjacent cell Formula, Compare two cell's text and based on results output a number Offrddrver Excel 4 03-23-2016 11:32 PM
Increase number in cell, based on value in adjacent cell How to conditionally format cells in Col. A if it matches adjacent cell in Col. B? alshcover Excel 2 06-03-2014 12:50 PM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft