dilini.gunathilake
New member
- Joined
- Feb 11, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I want to count no of vendors as Local and Foreign in each PCS group.
Local vendors have Vendor# starting from 21 and foreign vendors have Vendor# starting from 22.
I have more than 150000 data lines in my data sheet to do this analysis.
I really need the help of excel gurus!
See attachment which has a part of my file.
Local vendors have Vendor# starting from 21 and foreign vendors have Vendor# starting from 22.
I have more than 150000 data lines in my data sheet to do this analysis.
I really need the help of excel gurus!
See attachment which has a part of my file.