Return value between date range

[Kelli Webb]

Hi, It's Monday and my brain hasn't kicked into gear.

I would like to return the values for the date in Column F into Columns G H & I as per my example.

thank you!

Kelli

 

[NARAYANK991]

Hi ,

See if this will do.

Narayan

 

[bosco_yip]

Or...........

In G2, copied across to I2 and all down :

=IFERROR(INDEX(A$2:A$13,AGGREGATE(15,6,ROW($A$2:$A$13)-ROW($A$1)/($F2>=($B$2:$B$13))/($F2<=($C$2:$C$13)),1)),"")

Regards
Bosco

 

[Haz]

Or this.

 

[Kelli Webb]

Hi ,

See if this will do.

Narayan

thanks Narayan, always using the KISS principal

Cheers!

 

[Kelli Webb]

thanks Narayan, always using the KISS principal

Cheers!

Hi Narayan, What would the formula be to return a result for a date that falls within a date range?