Page 1 of 2 12 LastLast
Results 1 to 12 of 13

Thread: Excel Formula Needed...please help...

  1. #1
    n2cute is offline Advance Member+
    Last Online
    29th May 2017 @ 11:20 AM
    Join Date
    12 Dec 2007
    Location
    Lahore
    Age
    37
    Gender
    Male
    Posts
    2,503
    Threads
    133
    Credits
    453
    Thanked
    8

    Default Excel Formula Needed...please help...

    Dear Experts,

    Mujhay Excel ka formula chahiay....

    Screen shoot deikh lein aap ko samajh aa jaey gi....


    aap kay jawabaat ka muntazir....

    Last edited by n2cute; 14th October 2009 at 02:55 PM. Reason: screenshoot was not attached befor.....

  2. #2
    sbaig2's Avatar
    sbaig2 is offline Senior Member+
    Last Online
    30th November 2017 @ 03:03 PM
    Join Date
    30 Aug 2007
    Location
    لاہور
    Age
    63
    Gender
    Male
    Posts
    255
    Threads
    48
    Credits
    17
    Thanked
    14

    Default

    brother
    just type in A! 1 and in A2 2
    select both cell
    u will find a small aik nukta sa in cells kay right bottom side par bas us ko mouse say wahan tak khainch do jahan tak darkar hai
    Duaoon main yaad rakhna

    baig

  3. #3
    n2cute is offline Advance Member+
    Last Online
    29th May 2017 @ 11:20 AM
    Join Date
    12 Dec 2007
    Location
    Lahore
    Age
    37
    Gender
    Male
    Posts
    2,503
    Threads
    133
    Credits
    453
    Thanked
    8

    Default

    Thank you baig

    yeh tareqa to mujhay bhi pata hai actually main kuch cells merge kiaye howay hain iss liay woh iss method say nahi hoota..

    Kindly koi aour method bata dein

  4. #4
    arifraza's Avatar
    arifraza is offline Advance Member
    Last Online
    15th May 2022 @ 04:16 PM
    Join Date
    27 Sep 2006
    Location
    ALLAH ki Banani hoi Zameen Per
    Gender
    Male
    Posts
    1,674
    Threads
    155
    Credits
    148
    Thanked
    118

    Default

    nice.........
    [IMG]http://i919.***********.com/albums/ad33/arifraza/Denguevirus.jpg[/IMG]

  5. #5
    arifraza's Avatar
    arifraza is offline Advance Member
    Last Online
    15th May 2022 @ 04:16 PM
    Join Date
    27 Sep 2006
    Location
    ALLAH ki Banani hoi Zameen Per
    Gender
    Male
    Posts
    1,674
    Threads
    155
    Credits
    148
    Thanked
    118

    Default

    app aaisa karo Excel file share karo

  6. #6
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    10,901
    Thanked
    1925

    Default

    salam agar aap file ka screen shot de sakti he to ho sakta he aap ka masla hal ho jay

  7. #7
    n2cute is offline Advance Member+
    Last Online
    29th May 2017 @ 11:20 AM
    Join Date
    12 Dec 2007
    Location
    Lahore
    Age
    37
    Gender
    Male
    Posts
    2,503
    Threads
    133
    Credits
    453
    Thanked
    8

    Default

    please reply me ASAP


    thanks

  8. #8
    n2cute is offline Advance Member+
    Last Online
    29th May 2017 @ 11:20 AM
    Join Date
    12 Dec 2007
    Location
    Lahore
    Age
    37
    Gender
    Male
    Posts
    2,503
    Threads
    133
    Credits
    453
    Thanked
    8

    Default

    dear experts

    please help on urgent basis

  9. #9
    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

    salam::

    merge cell main no k leye thoda sa time dain subha fiqure out kar ke bataon ga. Lekan claim# main main ne notice kia ha ka emp# aik he hai jis k leye aap series 1.1 to 1.1o generate karna chahte ho. is k leye solution hazar ha. dobara apni sample data ki file attached kardain tu meharbani hogi. kion ka mughe aap k masle par kam karne k leya kafi typing karne pare ha aur main ne apni file main kia ha jis ki wajha se cell no mukhtalif honge. aap khood adjust karlejeye ge.


    Suppose your data start from c2. in b1 enter 0

    In cell b2 type this formula and copy down as long required

    =IF(C2=A1,LEFT(B1,FIND(".",B1&".",1)-1)&"."&MID(B1,FIND(".",B1,1)+1,255)+1,LEFT(B1,FIND (".",B1&".",1))+1&".1")
    agar aap se figure out na ho tu please apni file attached kar dain main kar donga inshallah.

    Apni duaon main yad rakhee.

    regard

    syar

  10. #10
    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



    App ke screen shot ke hisab se jahan tak main smjha hon k aap
    ne cell merge kar ka 1 no jo dia he wahan par employee no same he.
    2 no par employee no alag hai.
    agar cell merge karne ki bajae aap ye formula lagain tu jahan bhe naya
    empoyee no starthoga sirf us he ka samne count no aajaey ge for example.

    123 1
    123
    123
    345 2
    345
    678
    678 3
    If this approach acceptable then try this formula (work only when data enter c2)

    =if(c2<>"",IF(COUNTIF($C$2:C2,C2)=1,MAX($A$1:A1)+1 ,""),"") also see attached file sheet2.


    Lekan agar aap chahte ho ka same employee ka samne aik he no aae tu try this
    (work only when data enter c2)

    =IF(C2<>"",+COUNTIF($C$2:C2,C2),"")also see attached file sheet1.

    123 1
    123 1
    123 1
    345 2
    345 2
    678 3
    678 3


    Merge cell main bhee autonumber ho sakta hain leekan tricky hai. Is ki jagha
    agar macro solution ho tukiya acceptable ha.

    Regards
    Attached Files Attached Files

  11. #11
    n2cute is offline Advance Member+
    Last Online
    29th May 2017 @ 11:20 AM
    Join Date
    12 Dec 2007
    Location
    Lahore
    Age
    37
    Gender
    Male
    Posts
    2,503
    Threads
    133
    Credits
    453
    Thanked
    8

    Default

    Dear mr. Syar,

    can you please PM me your cell number.

    Thanks

  12. #12
    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



    Pm is not allowed to me bcz my posts are on 50-60.If u pm your cell no then i will text mine. or you need some help locate my email in my profile and mail to me.

    regards.

Page 1 of 2 12 LastLast

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. need excel formula
    By hassankarim in forum Ask an Expert
    Replies: 7
    Last Post: 28th June 2015, 05:12 AM
  3. help needed about EXCEL FORMULA
    By sunnytts in forum Ask an Expert
    Replies: 3
    Last Post: 23rd June 2015, 10:22 PM
  4. Solved Ms excel formula needed
    By salmanthegreat in forum Solved Problems (IT)
    Replies: 10
    Last Post: 3rd August 2012, 11:48 PM
  5. Excel Formula needed
    By Shoaibm in forum Ask an Expert
    Replies: 6
    Last Post: 18th July 2012, 11:51 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
  •