| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I pick start point in a range?
Hi, am trying to make an equation that varies the start point within a range.
Can I use a fixed cell to designate another non-fixed cell? thanks such as: (for range: f10:M10).. =IF(AND($A$3=4,$A$4=2),work g11:j11) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I pick start point in a range?
nastech wrote:
Hi, am trying to make an equation that varies the start point within a range. Can I use a fixed cell to designate another non-fixed cell? thanks such as: (for range: f10:M10).. =IF(AND($A$3=4,$A$4=2),work g11:j11) By equations I take it you mean formula. Look at the INDEX and OFFSET functions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| how to pick from a range of table values | Excel Worksheet Functions | |||
| How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
| Auto x range start value, xy charts | Charts and Charting in Excel | |||
Linear Mode
