How to highlight the extra data in column Closed

Question

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


Configuration: Windows 7 / Chrome 51.0.2704.103

Mazzaropi · Answer

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.

Sumit · Answer

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.

How to highlight the extra data in column

2 responses

Similar discussions

Subscribe To Our Newsletter!