Lookup Formula
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 |
Lookup Formula
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 |
Lookup Formula
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 |
All times are GMT +1. The time now is 12:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com