Extracting Unique List from a sheet

[MS Excel]

Hi all

I want to extract list of account no (one time only) from a sheet of
customer having multiple transaction where each customer having multiple
transaction.

Sheet 1:
S. NO CUST.CODE CUST.NAME AMT
1 0001 AAA 250
2 0002 BBB 300
3 0001 AAA 50
4 0001 AAA 100
5 0003 CCC 100
6 0004 DDD 99
7 0002 BBB 100

on SHEET 2, I want to have a list of these client (one client one time) as
follows:
0001 AAA
0002 BBB
0003 CCC
0004 DDD

 

[Bob Phillips]

Take a look at Data>Filter>Advanced Filter, it has an option to copy to
another location for unique items.

 

[Paul Sheppard]

Hi all

I want to extract list of account no (one time only) from a sheet of
customer having multiple transaction where each customer having
multiple
transaction.

Sheet 1:
S. NO CUST.CODE CUST.NAME AMT
1 0001 AAA 250
2 0002 BBB 300
3 0001 AAA 50
4 0001 AAA 100
5 0003 CCC 100
6 0004 DDD 99
7 0002 BBB 100

on SHEET 2, I want to have a list of these client (one client one time)
as
follows:
0001 AAA
0002 BBB
0003 CCC
0004 DDD

Hi MS Excel

Assuming your data to be in columns A-D, Select the data in Columns B &
C then > Data>Filter>Advanced Filter and Check the Unique records
onlybox, click in the Copy to box and enter F1