Love_123 said:
Salam Umeed hai sb kheryt se hn ge agr kisi ko ms excel agr achi khasi ati hai to please help kere mera kaam ruka hua hai or us mai bht time lg jata hai mjhe ek aise formule ki zaroort hai jis se mera kaam asaan ho jai mai sheet b attach ker raha hn example k liye lekin please help kerye ga to kerna kya hai mai apko btata hn....
ker ye hai k is sheet mai kahin(g) likha hai kahin(ml) likha hai kahin(gm) to kahin (oz) likha hai lekin in sb k sath ek value b likhi hai to mjhe excel mai ye kerna hai k jb(oz) ai to wo meri di hui value k brabr ho or mai us ko kisi b number k sath multiply kr skn or apni ek or total value k sath us ko multiply phr divde ker skn aisa koi formula hai agr kisi ko smjh nai i to please pm kr k apna contact number de de. file b attach kr di hai mai ne plzz help me yr....
Salam,
M aap ki bat naee smjha lekan follwoing formula aap ko har row m sa oz ki quantity alag kr dega. aage phr ap jo krna chahen is k sath.
Code:
=LEFT(IF(ISNUMBER(SEARCH("oz",A2)),RIGHT(A2,4),""),2)
regards,
Bookmarks