Table that shows difference between Tables

[jomaor1]

Hi everyone,

I have a Spreadsheed that control all the Finances at my house.
I'm trying to better analyse what we are currently spending outside our Projection.

So basically I have:

• 1 Table for Projection
• 1 Table for Actual

And I need another Table that brings whats isn't in both columns. (Pivot Table or with Formulas)

Follow attachment, thanks!

John.

[avk]

With two helper column to find out non match item.

[jomaor1]

Hi atul,

I would get by myself to your answer if it was what I needed.
It's just a detail: The "Not in Projection" or "Not in Actual" is only for Months, so for example:

If 'Rent' appears on Projection December but not in Actual December, and does show in Projection January, the Table should show 'Not in Actual'.
But your Formula on Columns "I" and "N" would show as 'Rent' because it found a Match for any month.

What I need is a match only if the month is the same. You have any idea how?

Nonetheless I like your approach