motherindia
Board Regular
- Joined
- Oct 15, 2015
- Messages
- 218
Hello sir,
Good evening,
I need to prepare pivot ike summary using filter function.
Following is the data structure;
ID No. Source code Amount
1. ABC 10000
1. ABC 5000
2. XYZ. 6000
3. DEF. 6500
3. DEF. 4500
OUTPUT Needed on another Sheet using Excel array formula Filter function and or Unique function.
ID No. Source code. Amount
1. ABC 15000
2. XYZ. 6000
3. DEF. 11000
Thanks,
Motherindia
Good evening,
I need to prepare pivot ike summary using filter function.
Following is the data structure;
ID No. Source code Amount
1. ABC 10000
1. ABC 5000
2. XYZ. 6000
3. DEF. 6500
3. DEF. 4500
OUTPUT Needed on another Sheet using Excel array formula Filter function and or Unique function.
ID No. Source code. Amount
1. ABC 15000
2. XYZ. 6000
3. DEF. 11000
Thanks,
Motherindia