MATCH() on a 2D array?
In Excel2003 is it possible to use something MATCH() on a 2D array, to
find the position of a particular entry? The result could be expressed
as a 2-element vector of {row,column} or as a single number
representing the "cell number" (e.g. in a 3x3 array, the middle cell
would be #5
Geoff Lambert
.
Relevant Pages
- Re: MATCH() on a 2D array?
... Now, this should be doable in VBA with a 2D array of, say integers. ... "Geoff Lambert" wrote: ... representing the "cell number" (e.g. in a 3x3 array, the middle cell ...
(microsoft.public.excel.misc) - Re: MATCH() on a 2D array?
... Assumes there is a single instance of the lookup value. ... Try this as an array so enter with Ctrl+Shift+Enter ... representing the "cell number" (e.g. in a 3x3 array, the middle cell ...
(microsoft.public.excel.misc) - Re: This question seems simpler than it actually is...
... find a lot of logic designers forget what HDL stands for... ... For the exercise I went ahead and did this with a 6 element array. ... type invect is array of entry; ... case mystate is ...
(comp.lang.vhdl) - Re: A critique of test-first...
... > silly to give a coding test to people of our level; ... Each message will have the cummulative probability. ... To find a random message get a number from randand find the entry ... Use a sparse/dense array of chars. ...
(comp.programming) - Re: A critique of test-first...
... > silly to give a coding test to people of our level; ... Each message will have the cummulative probability. ... To find a random message get a number from randand find the entry ... Use a sparse/dense array of chars. ...
(comp.programming) |
|
