Assigning certain data a value based on whole data

[Jveto]

Sorry for confusing title, I don't really know how to describe this.

Anyhow, I've gotten a lot of help on this site, but I'm still pretty new to coding. I have the ideas I want, but I don't know how to execute them. Hoping to learn more today!

Uploading my worksheet. Column A and Column B can have varying data and ranges, but will always be the two columns with the data I need to use in it. I would like the output to end up in column C. I gave an example of what a finished project would look like in column D.

So I want a couple things to happen.

First - Scan the values in row 1 column A. Look for matching values in all of column B.
If there is a matching value, print a "1" in the cell next to the matched B value. (Column C). Do this for all matching values in row 1.
Proceed to the next row. Scan values in A, look for matching values in B.
If you had matching values in row 1, print a "2" in the cell next to the matched B value.
If you did not have matching values in row 1, print a "1" in the cell next to the matched B value.

Repeat this until you have gone through every row in Column A. The next step would have a "3" if both previous rows had matching data. It would continue to count up until you reached the last row.

Second - Scan all values in column B. For all values that don't have a matching value in column A, print out a "222" in the cell next the B value into column C.

Finished!

Sorry if this was confusing. I'll be around for any help and questions.