Get nearest value of Duplicate records in excel

[sanjuss2]

Hi all,

I am hereby attaching a file which contains 3 tables having nomenclature as
Table 1
Table 2
Result Table

I need nearest i.e succeeding record from table 2 i.e. settlement date to match with table 1 column REFNO with table 2 column REFNO

It is a sample file & there are duplicate records in table 2, so I need the nearest date record of the settlement date for table 1 transaction date

Thanks in advance, your response saves my lots of time....

Sorry guys I have altered table 2 that have actual data is mentioned in the table


Pls Pls see the table again... actually I have deleted records from table 2 & now i have seen in actual data which are already there...

[sanjuss2]

iF VBA SOLUTION AVAILABLE IT WILL BE HIGHLY APPRICIATED

[AliGW]

Be patient and DON'T SHOUT at us!

[sanjuss2]

sorry.....

[menem]

Your file is .xlsx that VBA free file format.
And I'm not good in VBA, so while wait VBA from others member, please try this formula.

C3

Please Login or Register  to view this content.

(Your file was inserted 2 columns so please review in the file)


Regards.

[sanjuss2]

I will check this & thank you so much