Ascertain Unique value considering Two columns

  • Thread starter Thread starter Sort out uniuqe Data B2in 2colms.
  • Start date Start date
S

Sort out uniuqe Data B2in 2colms.

DearTroubleShooters, I just want Column B is keeping only the unique data
using its formula filtering from Column A as follows :

A B
......................................
1 Michael Michael
2 Ronald Ronald
3 Mendes Mendes
4 Nicolas Nicolas
5 Abraham Abraham
6 Ronald
7Michael
 
You would use Advance Filter to generate the Unique items

On the Data menu, point to Filter, and then click Advanced Filter.
In the Advanced Filter dialog box, click Copy to another location.
select the range that contains your data.
In the Copy to box, delete any information in the box or click in the box,
and then click on B2 where you want to copy the unique values.
Select the Unique records only check box, and click OK.

The unique values from the selected range are copied to the B2 and downward.


HTH

--
======================
Pls click Yes if this has help you
======================

Thank You

cheers,


I may be able to provide you a solution, there would be better solutions
from others.
 
Back
Top