Extracting Unique List from a sheet

  • Thread starter Thread starter MS Excel
  • Start date Start date
M

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
 
Take a look at Data>Filter>Advanced Filter, it has an option to copy to
another location for unique items.
 
MS said:
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
Click to expand...

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
 
Back
Top