Getting perfomance of each vendor using excel

Solved/Closed
johnrussel - Feb 23, 2010 at 12:31 AM
zmarlz04 Posts 10 Registration date Tuesday February 16, 2010 Status Member Last seen February 24, 2010 - Feb 24, 2010 at 05:51 AM
Hello,
What I want is to get an evaluation of every supplier. Let say I have 20 list of supplier and list of product I'd ordered, including quantity and promised date to be delivered. Let say if they failed to delivered the ordered item in the promised date, it will get a percentage in each line item, or if they changed the promised date they told earlier it will lessen their percentage evaluation. How could i do that. Or if you have anu suggestion how could i do that. please help me..thanks

3 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 23, 2010 at 12:58 AM
It is hard to tell what exactly you seek. From the message, I am getting idea that you dont have requirement laid out. Perhaps if you could add a sample sheet which has the data and how you want it to show up based upon data, some suggestion can be made
0
zmarlz04 Posts 10 Registration date Tuesday February 16, 2010 Status Member Last seen February 24, 2010
Feb 23, 2010 at 04:30 AM
ok..here's maybe much easier...
count the cell if is non blank and if it has unique date/value...the cell to be count is from column D: to Column Z..
..thanks
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 23, 2010 at 08:43 AM
Thank you so much for giving an alternative easier question. Hope I pass

=SUM(IF(FREQUENCY(D1:Z1,D1:Z1)>0,1))
0
zmarlz04 Posts 10 Registration date Tuesday February 16, 2010 Status Member Last seen February 24, 2010 > rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022
Feb 24, 2010 at 04:10 AM
Thanks for your answer..I'll try it....ur such an EXCELLent guy..wow......keep up
0
zmarlz04 Posts 10 Registration date Tuesday February 16, 2010 Status Member Last seen February 24, 2010
Feb 24, 2010 at 05:51 AM
dude, its working ...thanks you.till next time...
0