Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using particular positions within an array
I have an array which is 12 cells long. I will need to have a variable on
the sheet which will tell me which if the last position (or ideally, first and last positions, or super-ideally, which are the individual positions) I need to use for a given calculation. Is there a function that will look at the named array and within something like a SUM function, only use the points from the array which match the positions? In other words, what is the function that indicates a particular reference spot in an array? Thx. -- Boris |
#2
|
|||
|
|||
using particular positions within an array
Check out the INDEX or OFFSET functions.
"BorisS" wrote: I have an array which is 12 cells long. I will need to have a variable on the sheet which will tell me which if the last position (or ideally, first and last positions, or super-ideally, which are the individual positions) I need to use for a given calculation. Is there a function that will look at the named array and within something like a SUM function, only use the points from the array which match the positions? In other words, what is the function that indicates a particular reference spot in an array? Thx. -- Boris |
#3
|
|||
|
|||
using particular positions within an array
On Sat, 12 Nov 2005 05:50:02 -0800, BorisS
wrote: I have an array which is 12 cells long. I will need to have a variable on the sheet which will tell me which if the last position (or ideally, first and last positions, or super-ideally, which are the individual positions) I need to use for a given calculation. Is there a function that will look at the named array and within something like a SUM function, only use the points from the array which match the positions? In other words, what is the function that indicates a particular reference spot in an array? Thx. Look at the INDEX function --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting all positions of a value in an array or reference | Excel Discussion (Misc queries) | |||
Excel array formulas | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |