frustraded with conditional values return in a range of dates

S

ser_man

Hi, i have a range of dates, and i need to check in another sheet o
excel if there was any value bigger than zero in those range of dates
if there was a value, i need it to return the value (as marked in th
second coloumn) and the date that is written next to it on the 1s
coloumn.

Could you please help me? i'm trying to figure it out by myself fo
three days, without any success.

Thank you

+-------------------------------------------------------------------
|Filename: 11.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=823
|Filename: 22.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=824
+-------------------------------------------------------------------
 
S

ser_man

any help? someone? please

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
Top