• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract data according to a date range

Niranjan1979

New Member
hi All, I want an excel formula where I need to extract a result based on two dates also it needs to check for the ID. Because same date range can be for many IDS. I have attached an xls file with result on RHS in yellow. I want a formula for Result. I tried index and match.. didnt picked up according to ID. Kindly suggest
 

Attachments

  • Excel.xlsx
    10 KB · Views: 16
I understand the need for a unique ID but what field should the "result" be based on and what is considered the 1st day of the week in this data? It may also help to understand more about the data as I assume there will be more than 4 or 5 records.
 
Back
Top