Duplicate Data Unique Record

[JAMIR]

Hello Excel Ninjas,

I have attached sample workbook. I need get unique record of Duplicate Value.

There is Inward-Outward Sheet & RC Register Sheet. In RC Register Sheet i want get the latest unique record from Inward-Outward Sheet of Vehicle No.

i.e. vehicle no.MH15AK8090 is came on 11-04-16 & again came on 21-04-16, But i get only 11-04-16 record correct.

You are requested to please help me on this matter. Its highly appreciated.

Regards,

Zameer

 

[Naresh Yadav]

Dear jamir,

pls try this one and finish with CTRL+SHIFT+ENTER

=MAX(IF([@[Vehicle No]]='Inward-Outward'!$D$41:$D$133,'Inward-Outward'!$C$41:$C$133))

 

[JAMIR]

Hello Naresh,

Thanks for reply. I dont want max value. I need all the records related Vehicle No. i.e. Vehicle No. MH15AK8090 is comes two time 1st on 11-04-16 & 2nd 21-04-16.

So i need the MH15AK8090 Vehicle In Date / Progressive Kms & EOC Kms.

Thanks

Zameer

 

[Naresh Yadav]

Dear Jamir,

here is the solution as required and finish the formula with CTRL+SHIFT+ENTER
excel file is also attached for your reference..

=INDEX('Inward-Outward'!$C$41:$C$133,SMALL(IF([@[Vehicle No]]='Inward-Outward'!$D$41:$D$133,ROW('Inward-Outward'!$B$41:$B$133)-40),ROW(A1)))

 

[bosco_yip]

Extract data from a large summary sheet, using helper column usually is the most effective way and in avoid to use array formula :

1] Please see file attached

2] Helper column in Inward-Outward sheet Column W

3] Criteria cell in RE Register sheet C2

4] All values generated by formulae are copy down with error trap.

Regards
Bosco

 

[JAMIR]

Hello Naresh

Thank you very much for your valuable help.

Hello Bosco_yip

Thank you very much for your great support.

Please keep help me hereafter.......

Warm Regards,


Zameer