#1
|
|||
|
|||
Change formula cell range based on cell value
Is there a way to control a formula cell range for a chart based on a cell value? |
#2
|
||||
|
||||
Hello,
could you please elaborate ? Perhaps post a small sample sheet showing what you want to achieve ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Want to generate title comments based on results of a pivot table, Since the range would change based on the data results I would need to have the cell that I am using to create the comments be able to change based on the range result of the pivot table.
|
#4
|
||||
|
||||
To post a sheet, click on Go Advanced and follow the wizard opened by " Manage Attachments" button
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Msg. for Pecoflyer-Excel formula help
Pecoflyer:
Y'day you helped me with a formula for replacing contents of a cell. Thanks a ton for that. I had a very small addition to it. In the attached spreadsheet please note the rows 16 & 17 (columns B & E- which is the data) and column F which I need using the formula. Thanks again |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating formula based on if data is correct in cell | MattMurdock | Excel | 1 | 08-06-2012 03:11 AM |
change values based on cell | ubns | Excel | 1 | 05-21-2012 06:28 PM |
How to highlight the row based on cell value? | Learner7 | Excel | 1 | 12-11-2011 02:28 AM |
Limit cell range use | talkinglens | Excel | 6 | 12-31-2010 08:43 PM |
Moving formula range multiple cells when moving sum over one cell | FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |