How to reconcile transactions list to a budget monitoring master sheet?

[Bloberto]

So for work I have a salary budget monitoring sheet that uses sumifs to find 3 criteria’s, an employee no, position number, and a cost centre. Each month I download the salary report that is about 4000 rows long and 20 columns wide and filter these salary transactions into my master monitoring sheet using the sumifs mentioned above. Each month we get new employees and some people move teams (cost centre) and so a new row must be added each time this happens. Is there an easy way for me to find these new employees from the transactions download based on their employee number, cost centre and position number and get a list of these 3 combined columns for those that are not currently in my master sheet?

I’m the past I have been finding these by creating a pivot for each of my master sheet and transactions sheet, adding rows of the cost centres and employee numbers and comparing these pivots row by row to find what is missing, but this is really time consuming.

 

[Joe4]

Welcome to the Board!

What you are describing is really a relational database, and typically, these types of things are much easier to do with a relational database program like Microsoft Access (though you can use Excel's Power Query to do lots of database type operations). In Access, it is easy to create filtered queries, and compare one query to another to identify unmatched records.