Find Date in rows was contain Text "1"

[coolzsters]

Dear all Master....

Example :

A	B	C	D	F	G	H	I	J
Items	7/6/2018	7/7/2018	7/8/2018	7/9/2018	7/10/2018	7/11/2018	7/12/2018	Result
Bananas		1	1	1				?
Apple			1	1	1			?
Orange					1	1	1	?

<tbody>
</tbody>

I really need help, i want to find a Date in result column when found first "1" variables...

 

[JoeMo]

In I2 and copy down:

=INDEX($B$1:$H$4,1,MATCH(1,$B2:$H2,0))

 

[coolzsters]

Wow.. it's work.. Very thanks JoeMo

 

[ttray33y]

another option: copy and paste ( ctrl+shift ENTER ) <enter>

=OFFSET(INDEX(B2:H2,MATCH(FALSE,ISBLANK(B2:H2),0)),ROW(A1)*-1,0)

drag formula down.</enter>

 

[Peter_SSs]

another option: copy and paste ( ctrl+shift ENTER ) <enter>

=OFFSET(INDEX(B2:H2,MATCH(FALSE,ISBLANK(B2:H2),0)),ROW(A1)*-1,0)

drag formula down.</enter>

A few comments
1. Apart from requiring the additional CSE complication on entry, OFFSET is a volatile function so could potentially impact the sheet's performance.
2. It is not robust. For example, after the sheet is set up with your formula, insert a new row 1 & look what happens.
3. If the 1's and blanks in the data happen to be populated by a formula, your formula will always return the date from column B.


One further comment, JoeMo's formula can be simplified a little to

=INDEX(B$1:H$1,MATCH(1,B2:H2,0))

BTW, coolzsters, welcome to the MrExcel board!

 

[ttray33y]

points taken, thanks Pet.

 

[coolzsters]

Thanks Mr. Pet..