Previous Topic Next Topic

Getting perfomance of each vendor using excel

Solved/Closed
johnrussel - 23 Feb 2010 à 00:31
zmarlz04 Posts 10 Registration date Tuesday 16 February 2010 Status Member Last seen 24 February 2010 - 24 Feb 2010 à 05:51
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
Related:

3 responses

Réponse 1 / 3
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
23 Feb 2010 à 00:58
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
Réponse 2 / 3
zmarlz04 Posts 10 Registration date Tuesday 16 February 2010 Status Member Last seen 24 February 2010
23 Feb 2010 à 04:30
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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
23 Feb 2010 à 08:43
Thank you so much for giving an alternative easier question. Hope I pass

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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses