How to highlight the extra data in column

[Closed]
Report
-
 Sumit -
Hello,
I want to get the extra data in a column when compared to other column.

For Ex:
If ColumnA has following data
1
2
2
3
5
& column B has:
5
1
9
2
8

then when A compared to B the output should be:
2
3

Please help me with the formula. Thanks in advance


2 replies

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
Sumit, Good afternoon.

Sorry but it's clear the question.

Whats is the used rule to obtain this kind of result when comparing you columns?

It's necessary to know the rule to build a formula that will help you.
Hi, actually I have to find the numbers from column A which are not present in column B also if a number is present in column A 3 times and only once in column B then two instances should be present in the output.