Comparing Arrays

heimdaloz

New Member
Joined
Feb 1, 2018
Messages
8
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
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
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

New Member
Joined
Feb 1, 2018
Messages
8
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,029
Messages
5,466,117
Members
406,468
Latest member
Toto Li

This Week's Hot Topics

Top