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