ExcelBanter - frustraded with conditional values return in a range of dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - frustraded with conditional values return in a range of dates (https://www.excelbanter.com/excel-worksheet-functions/448489-frustraded-conditional-values-return-range-dates.html)

ser_man

frustraded with conditional values return in a range of dates

2 Attachment(s)

Hi, i have a range of dates, and i need to check in another sheet of 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 the second coloumn) and the date that is written next to it on the 1st coloumn.

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

Thank you.

ser_man

any help? someone? please?

All times are GMT +1. The time now is 07:20 AM.