Find Date in rows was contain Text "1"

[coolzsters]

Dear all Master....

Example :

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]Items[/TD]
[TD]7/6/2018[/TD]
[TD]7/7/2018[/TD]
[TD]7/8/2018[/TD]
[TD]7/9/2018[/TD]
[TD]7/10/2018[/TD]
[TD]7/11/2018[/TD]
[TD]7/12/2018[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD="align: center"]?[/TD]
[/TR]
</tbody>[/TABLE]



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..