Auto Populate Text from a value between two columns

[EXCELBENCH]

Hi
Need help on a simple formula and function.
I am trying to get the remaining value populated on Column C
Actual and target are manually populated. I just need to get a list from Column A & B as to what is still missing.

Sample 1.png

[thomglea]

2 questions:

1. Are you always looking for values that are currently in Column A but not in Column B? Or would you want to look going the other way too?
2. Your profile says MS 2016, join date 2015. Since you joined, have you upgraded to Microsoft 365?

[EXCELBENCH]

1. Are you always looking for values that are currently in Column A but not in Column B? Or would you want to look going the other way too? On Column A only
2. Your profile says MS 2016, join date 2015. Since you joined, have you upgraded to Microsoft 365? Yes upgraded to 365

[thomglea]

In column C, use a COUNTIF formula to see if the numbers in Column A are in Column B. Copy that down the length of Column A.

Please Login or Register  to view this content.

Then, off to the right in E1, use this formula:

Please Login or Register  to view this content.

There may be a way to combine the two into one formula, but I do not know how.