Hello guys,

I have the following problem:
- 2 columns with amounts;
- the specific amounts can appear more than once;
- I have to compare both columns and mark (f. ex. with "yellow" filling) the
amounts that appear in both of them... (seems easy until now)
- ... but you have to consider every number on its own, i.e. if:

column A: 5, 2, 2, 1, 8
column B: 5, 5, 2, 1, 1, 1

then in column A we will color 5, 2, 1, (it means that we will leave
unfilled: 2, 8) - it doesn't matter which "2" is colored and which not
in column B we will color 5, 2, 1 (and leave unfilled: 5, 1, 1) - it doesn't
matter which "1" (or "5") is colored and which is not...

Any ideas how to achieve this?
Let me know if it's not sufficiently clear...

P.S. If it's easier, we could also make a VBA that will delete both
instances (one from column A and one from column B) once it found the match,
but the final result should be the same, i. e. (in our exemple) it should
leave "2" and "8" in column A and "5", "1" and "1" in column B.

Many thanks for your help,