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