I would like to write a formula that will do the following:

A B C D
1 Jan Feb Mar Apr
2 x x x
3 x x x x
4 x x
5 x

Looking for a formula to return the month of the first appearance of "x."
So "Feb" for row 2 "Jan" for row 3 "Mar" for row 4 and so on.

Any help is greatly appreciated.

Thanks

Try

=index($A$1:$D$1,match("x",A1:D1,0))

and drag down.

If you aren't getting a match, try replacing space with nothing using CTRL+H
in the range containing the xs

"Eric" wrote:

I would like to write a formula that will do the following:

A B C D
1 Jan Feb Mar Apr
2 x x x
3 x x x x
4 x x
5 x

Looking for a formula to return the month of the first appearance of "x."
So "Feb" for row 2 "Jan" for row 3 "Mar" for row 4 and so on.

Any help is greatly appreciated.

Thanks

Hi,

enter the following formula and then format the cell to MMM custom format

=--(MATCH("x",A2:D2,)&"-8")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Eric" wrote:

I would like to write a formula that will do the following:

A B C D
1 Jan Feb Mar Apr
2 x x x
3 x x x x
4 x x
5 x

Looking for a formula to return the month of the first appearance of "x."
So "Feb" for row 2 "Jan" for row 3 "Mar" for row 4 and so on.

Any help is greatly appreciated.

Thanks