1.

Solve : Excel query for a value linked to a reference cell?

Answer» <html><body><p>Hi,<br/>Could someone help with an excel query? I want to find the most recent date for each person and then choose the value two cells over for each ID? <br/><br/>The following does not work as the MAX() range includes a mixture of dates and values:<br/>=HLOOKUP(MAX(A1,E1,I1),A1:L1,2,0)<br/><br/>The database is organised as such:<br/><br/>ID Date1 Value1 Value2 Date2 Value1 Value2 Date3 Value1 Value2........<br/>1 <br/>2<br/>3<br/>4<br/>.<br/>.<br/>.<br/><br/>One person (ID) may have two date/value <a href="https://interviewquestions.tuteehub.com/tag/entries-972860" style="font-weight:bold;" target="_blank" title="Click to know more about ENTRIES">ENTRIES</a> and <a href="https://interviewquestions.tuteehub.com/tag/another-876628" style="font-weight:bold;" target="_blank" title="Click to know more about ANOTHER">ANOTHER</a> may have <a href="https://interviewquestions.tuteehub.com/tag/ten-659720" style="font-weight:bold;" target="_blank" title="Click to know more about TEN">TEN</a> so the reference cell (most recent date) will differ for each person, and this will change overtime as more dates/values are entered.<br/><br/>Could someone provide me with a <a href="https://interviewquestions.tuteehub.com/tag/solution-25781" style="font-weight:bold;" target="_blank" title="Click to know more about SOLUTION">SOLUTION</a> to find Value2 for the most recent date for each person?<br/><br/><a href="https://interviewquestions.tuteehub.com/tag/kind-25540" style="font-weight:bold;" target="_blank" title="Click to know more about KIND">KIND</a> regards,<br/><br/>Maria<br/></p></body></html>


Discussion

No Comment Found

Related InterviewSolutions