Column number form an array

[michelle439731]

Afternoon,

I would like to know how to output the column number from a particular array
that a specific output is found in.

For example: what is the column number of X in the following array
V, W, X, Y, Z?
3

Thank you!

Michelle

 

[T. Valko]

Try this:

=MATCH("x",{"V","W","X","Y","Z"},0)

Or, if the entry is in a range of cells:

=MATCH("x",V1:Z1,0)

 

[michelle439731]

Smashing.

Thanks ever so.

Mwah!

 

[StuartBisset]

Michelle

You should try to explain your problem a bit more thoroughly if you
want to get a good quality answer to your problem. Asking about an
array makes me think that you are asking a vba question, in which case
you should probably ask it in this http://groups.google.com/group/microsoft.public.excel.programming/topics
discussion group. You should mention what version of excel you are
using?, how the array is populated?, is it a vba solution you need?,
is it a formulae solution you need?, is the data held in a worksheet?
Its very difficult to understand what you are trying to do from what
you have written.

Regards

Stuart Bisset
www.insightmodelling.com