Mandeep da,
Your UDF function is working fine. it is really nice concept that you
did. thanks once again for your valuable time regarding my issue.. i
also got a solution from Paul .though currently i did not get any
problem, then now i analysis whether any discrepancy is there or not
.. if i get
Hey Nur,
Kindly find the attached UDF just type the formula in sheet First
percentage/Second percentage it will give to appropriate result. if text
does not contain second percentage value it will give wrong result.
Function Firstpercentage(txt) As String
Dim k() As String
Dim x As Variant
Dear Nur,
Thanks to appreciate.
Actually I was doing my office work yes it is possible to reference text
inside the formula.But I need time because I have to do my ofc work too :),
Soon I will submit it your percentage formula too.
On Thursday, November 20, 2014 1:22:52 PM UTC+5:30, Nur wro
Mandeep da,
Take my respect ,yes you did excellent job for me . the formula
results are 100% correct . please take time for solving % issue. Is
it possible to implement reference text inside the formula . if not
possible then use another column to keep the “ reference text “ , it
might be colu
Try dis kind of formulas. Don't delete the hide rows reference you can
shift it. I will provide you a solution soon for % column too.
Regards,
Mandeep Baluja
*Excel Specialist. *
On Thursday, November 20, 2014 1:22:52 PM UTC+5:30, Nur wrote:
>
> Dear all, I need to extract the partial co
