Well, since you asked, the problem is more complicated than that :-)
I have a kind of a table with a list of values on the left columns and a
matrix on the right ones.
Each value on the left can have one or more appearances in the matrix
represented by the value 1 (on the equivalent row).
it looks like this:

Name Last Name 1st 2nd 3rd 4th 5th
Tim Brown 1 1
Jack Erdwin 1
Maya Kohen 1 1 1

I want to represent the information like this or in similar form:
Name Position
Tim 1st
Jack 2nd
Tim 3rd
Maya 3rd
Maya 4th
Maya 5th

How can I extract the names of all who are in 1st position, then all who are
in 2nd position etc.?

"Bernie Deitrick" wrote:

Yossi,

Yes, using an array formula entered into multiple cells. Is that what you
want, or do you want the values returned to a single cell? If so, you could
use a user-defined-function, or use two formulas (one additional one to
concatenate the results of the multi-cell array formula.)

Any preference? But, more importantly, how will you be using that
information?

HTH,
Bernie
MS Excel MVP


"Yossi" wrote in message
...
Hi,
I have a reference to a row and in that row, several cells have the value
of
1. I would like to get the positions of all of them from the array.
For example:
A1 A2 A3 A4 A5 A6
1 0 1 1 0 0

I would like to get A1, A3, A4
is there a way to retrieve that information in a single formula?
thanks