#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
To me it is not obvious what you want, especially the image I find confusing.
If the attached is not what you want, you must be more specific. |
#3
|
|||
|
|||
Deleted by moderation. There is already an existing thread
|
#4
|
|||
|
|||
Maybe something like shown in Data Build!B7:B8
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Formula, Compare two cell's text and based on results output a number | Offrddrver | Excel | 4 | 03-23-2016 11:32 PM |
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 |