How can i look up duplicate copy in latest date

[realtop17]

ex: sheet 1

1 S/N DATE

2 AB 1/1/2012

3 CD 1/1/2012

4 AB 2/2/2012

5 CD 2/2/2012

6 EF 3/3/2012

ex: sheet 2

1 S/N DATE

2 AB ?

3 CD ?

4 EF ?

this are the result iwant when ilook up sheet2

1 S/N DATE

2 AB 2/2/12

3 CD 2/2/12

4 EF 3/3/2012


Please help on this.


thank you,

realtop

 

[NARAYANK991]

Hi ,


Try this :


=MAX(IF(Sheet1!$B$2:$B$6=Sheet2!B2,Sheet1!$C$2:$C$6))


This is to be entered as an array formula , using CTRL SHIFT ENTER.


From the limited number of examples given , it is difficult to know whether you are looking for the date which occurs last in the range , or you are looking for the latest date ( by way of value ).


For example , if the first date against CD were to be October 2012 , while the second date against CD were to be June 2012 , which would you want as the output ? October 2012 because it is the latest date , or June 2012 because it is the date which occurs later in the range ?


Narayan

 

[Guest]

So every day at the computer time are delivered directly to the Internet,buck,each other,don, remuneration is also hit me on the card

 

[Guest]

What?,drew, relationresultSaid,her voice was suddenly low, full of sorrow:relationresultNow,taylor,what is also important things?Anyway,this happened,marcus,we can never go back to before the sort of state

 

[Guest]

Random face of boxing,arnold, the hero Jia Buzhu pack of wolves,bartley! Any more afraid of a little,lewis, so many people are also holding a guy today a beating endure given

 

[realtop17]

Hi Narayank991,


thank you for your clarification about my question, base on your example i want the latest date output october 2012. can you give us the formula or the best automation like macro.


thank you,

realtop

 

[NARAYANK991]

Hi ,


If you want the latest date , the formula which was given earlier should do the job.


Narayan

 

[realtop17]

Thank you NARAYANK991 wow!!!!!!!!