Results 1 to 3 of 3

Thread: MS Excel Ka Ustad hai to yahan ao

  1. #1
    Love_123's Avatar
    Love_123 is offline Advance Member
    Last Online
    30th May 2022 @ 07:30 PM
    Join Date
    04 Nov 2009
    Gender
    Male
    Posts
    1,270
    Threads
    161
    Credits
    63
    Thanked
    85

    Default MS Excel Ka Ustad hai to yahan ao

    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....
    Attached Files Attached Files

    Max Image Size = 30 KB

  2. #2
    Geeky's Avatar
    Geeky is offline Senior Member+
    Last Online
    12th July 2016 @ 10:31 AM
    Join Date
    12 Mar 2016
    Location
    Earth
    Age
    28
    Gender
    Male
    Posts
    271
    Threads
    4
    Credits
    1,606
    Thanked
    13

    Default

    you mean (=lookup) formula?
    Did u chk this
    ?

  3. #3
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote Love_123 said: View Post
    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,

Similar Threads

  1. to Ustad
    By iqu-76 in forum Khatm-e-Nabuwat
    Replies: 49
    Last Post: 18th January 2010, 11:50 PM
  2. ustad
    By iMr@N B@LocH in forum Sindhi
    Replies: 1
    Last Post: 15th November 2009, 02:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •