![]() |
#1
|
|||
|
|||
![]()
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, ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
wmedjaxnjr | Excel | 1 | 04-09-2016 04:22 PM |
![]() |
Offrddrver | Excel | 4 | 03-23-2016 11:32 PM |
![]() |
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 |