Need help on the enclosed sample data

[aksan782]

Hi All,

On the enclosed data Column A has the PDD number and its corresponding insert date is available on Column C (multiple rows).

If Column A Value is S054.01015 then i want the result to be
01/05/2012 19:27:25 which is the highest among others in Column C.

Like wise if Column A Value is S054.01028 then i want the result to be
01/03/2012 15:36:24 which is the highest among others in Column C.

Thanks in advance for your help in addressing this.

 

[NARAYANK991]

Hi ,

See the file.

Narayan

 

[prasaddn]

Hi,

Alternate solution:
A) Sort the data with:
1. level 1 PDD_num (A-Z) and
2. level 2 Insert date column (Z-A),
3. on the dialog box, select treat anything looks like number as number. This (3rd step is required in this case as the data and time is stored as general format.)

B) Apply a normal vlookup and you get the same output.

Regards,
Prasad DN

 

[aksan782]

Thanks to both for your help.

@NARAYANK991 Could you please explain me the formula you have used.