|I want to have some udf (to be added in Excel ADD - IN) which can refer the relevant number from a given file on a network location (preferable it should be accessible by multiple persons) |
I dont mind even doing hard coding, but reference from file is preferable.
and for 2 given values it should give me difference.
Source Data (Related with Diamond terminology)
FL - 1
IF - 2
VVS1 - 3
VVS2 - 4
VS1 - 5
I want a function named GetPDif(P1 as String , P2 as String)
=GetPDif ( "IF" , "VVS2") shall give me the result of 2 (relevant number of IF) - 4 (relveant number of VVS2) = -2
Thanks in advance for help