I would like to ask you to help me to create my own formulas in VBA
I am a purchaser and my job consist of evaluating the offers from several companies for a certain range of products. From their offers I am choosing the best prices and the supplier where to buy the particular product from that range.
So I need to figure out :
1) Best (Minimum)price
2) Supplier who has the best price for the particular product.
It is an easy formula to set up the minimum price bigger than 0 : =IFERROR(SMALL(range;COUNTIF(range;0)+1);MIN(range))
In my table it is column C =IFERROR(SMALL(G1:J1;COUNTIF(G1:J1;0)+1);MIN(G1:J1))
When I have minimum price I can look for the name of the company with match and index formulas. In my table it is column E =INDEX($E$2:$H$2;MATCH(C1;E1:H1;0)).
Unfortunately, I do not know how to create my own formulas, so I do not have to think about them and write them all the times. Can somebody help me here what exsactly do I have to write to VBA module when I want to create my own formula for BESTSUPLIER and waht for BESTVALUE
1.
Public Function BESTVALUE()
...................................
End Function
2.
Public Function BESTSUPLIER()
......................
End Function
Sorry for the poor description of the problem but my english is far from good but I hope you will understand what I need. I am attaching the excel file "evaluation" from which you can understand it.
Bookmarks