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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 7
Search a range for instances of a text string, return neighboring cell values each ti 2
Complex Vlookup 1
Custom Autonumber with Prefix and Category Grouping 3
Returning a value from a range 1
Get sum of values in a cell based on unique values in another cell 3
IF Statement Table Help 1
return a value depending on two previous values 1

Top