Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 5
Default frustraded with conditional values return in a range of dates

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.
Attached Images
  
  #2   Report Post  
Junior Member
 
Posts: 5
Default

any help? someone? please?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
return date from range of dates with if statement Joe Excel Worksheet Functions 3 March 3rd 09 11:24 AM
Sum values in a range conditional upon dates and an additional fie Jay59874 Excel Worksheet Functions 7 December 12th 08 07:36 PM
Return a value for a range of dates Waters Excel Worksheet Functions 1 May 27th 06 03:18 AM
return based on range of dates Matt Excel Worksheet Functions 6 February 15th 06 08:36 PM
conditional formula: return 1 of 4 values Pladdy Excel Worksheet Functions 3 January 15th 06 06:13 PM


All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"