Comparing Arrays

[heimdaloz]

Hi,

I have two arrays that contain a date, amount and description. I need to compare the two arrays and then process the differences.

Possibly place the contents in another array so they can be processed or output them into a sheet.

Thanks

 

[James006]

Hi,

Unfortunately your request is too generic ...

How do you define " compare " ?

Are the differences from field to field ... or between their respective concatenations ...?

 

[heimdaloz]

Thanks James.

I am loading a bank statement into an array and I want to load the data into a spreadsheet that has the transactions for the financial year.

The first file of the year loads the statement into an array and then outputs into a sheet. I was hoping the subsequent file could be loaded into an array and then I would load the existing financial data into another array. Compare the two and find those transactions that only exist in the new file. I could then output the data into the exist spreadsheet, avoiding duplicates. I had thought I would load the difference into an array and then output it.

I figure if I compare the transaction date, amount and description, where I can't find a match I would then write the record out.

Thanks