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

Thread: "Excel formula"

  1. #1
    mugheez's Avatar
    mugheez is offline Senior Member+
    Last Online
    20th December 2016 @ 12:26 PM
    Join Date
    27 Nov 2010
    Age
    35
    Gender
    Male
    Posts
    485
    Threads
    97
    Credits
    0
    Thanked
    13

    Default "Excel formula"

    Asalamualaikum!
    Hope all members will be fine.
    Mujhay excel main students k marks ki base pe positions assign karni hain.means 34 students hain oon ko according to their marks 34 positions assign karni hai.Highest marks holder student ko 1st then lower one ko 2nd and so on.is it possible?if anybody knows then tell me plz.
    jazakALLAH!

  2. #2
    Waqar Rasheed's Avatar
    Waqar Rasheed is offline Advance Member
    Last Online
    17th October 2023 @ 07:18 PM
    Join Date
    13 Jul 2010
    Location
    Lahore
    Age
    33
    Gender
    Male
    Posts
    12,751
    Threads
    610
    Credits
    301
    Thanked
    2647

    Default

    دوست یہاں وزٹ کریں
    http://www.itdunya.com/t300546/

  3. #3
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    Ap Rank ka function istimal kar sakte hain ye automatically numbers assign kar de ga.
    For example agar ap k students k final marks B2 se B35 tak hain tu C2 m below formula lekhain aur copy down as far as required. Change references accordingly.

    Code:
    =RANK(B2,$B$2:$B$35)
    Hope this will help you. Lekan aik chota sa masla ha rank function k sath. Agar kisi students k darmeyan tie ho yani number aik jese hon tu ye dono numbers ko aik e rank de ga lekan us k bad wale students k grader aik darga omit kar gai ga. Jis k leye formula thoda different ho ga. Agar aisa ha tu try this
    Code:
    =RANK(B2,$B$2:$B$35,0)+COUNTIF($B$2:$B$35,B2)-1
    regards

  4. #4
    mugheez's Avatar
    mugheez is offline Senior Member+
    Last Online
    20th December 2016 @ 12:26 PM
    Join Date
    27 Nov 2010
    Age
    35
    Gender
    Male
    Posts
    485
    Threads
    97
    Credits
    0
    Thanked
    13

    Default

    Syar bhai aor faisal bhai mujhay formula smaj to aa gaya hai but ye apply nahi ho raha muj se.

  5. #5
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    بعض مرتبہ کچھ طالب علم ایک جتنے نمبر بھی حاصل کرلیتے ہیں ان کو بھی اپنی مارکس شیٹ میں یاد رکھے گا۔
    جی یہ ممکن ہے جو لنک آپ کو دیا گیا ہے وہاں اپنا مسلہ پوسٹ کریں آسان سا جواب مل جائے گا جو کہ آنے والے وقتوںمیں آپ خود بھی کر سکیں گے۔ ورنہ ہم حاضر ہیں

  6. #6
    mugheez's Avatar
    mugheez is offline Senior Member+
    Last Online
    20th December 2016 @ 12:26 PM
    Join Date
    27 Nov 2010
    Age
    35
    Gender
    Male
    Posts
    485
    Threads
    97
    Credits
    0
    Thanked
    13

    Default

    Nahi haseeb bhai formula apply karnay se positions assign hi nahi ho rahi.same marks ki positions ki problem to bad ki bat hai,mujhay to formula apply karnay se output hi nahi mili rahi.Ab jesay ye 11 students k marks hain out of 175.yahan formula kis cell main aor kesay apply karun.guide plz kunk muj se to nahi hua.
    jazakALLAH!
    Attached Images Attached Images  

  7. #7
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    As per your screen shot.
    B19 m formula enter karain aur neeche tak copy kar dain. Agar list lambi ho tu references change kar lain.

    Code:
    =RANK(A19,$A$19:$A$30)+COUNTIF($A$19:A19,A19)-1
    Agar Phir bhe formula kam na kara tu apni sample sheet upload kar dain. m formula laga donga. Aur ye ensure karain k ap ne figure enter ki hon na ka as text.

    regards

  8. #8
    mugheez's Avatar
    mugheez is offline Senior Member+
    Last Online
    20th December 2016 @ 12:26 PM
    Join Date
    27 Nov 2010
    Age
    35
    Gender
    Male
    Posts
    485
    Threads
    97
    Credits
    0
    Thanked
    13

    Default

    Asalamualaikum!
    Syar bhai shukria.mujhay formula ki smaj aa gai hai.apply bhi hop gaya hai.but ye thk positions assign nahi kar raha hai.jahan 2 students k same marks hain wahan 2no ko same positions assign honi chaheay but ye 2no ko different positions assign kar raha hai jis ki waja se over all positions disturb ho rahi hain.
    jazakALLAH!

  9. #9
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Enter this array formula in A19 and copy down as far as required.

    Code:
    =SUM(IF(A19<$A$19:$A$30,1/COUNTIF($A$19:$A$30,$A$19:$A$30)))+1
    Formula must be entered with "CONTROL+SHIFT+ENTER"


    regards

  10. #10
    mugheez's Avatar
    mugheez is offline Senior Member+
    Last Online
    20th December 2016 @ 12:26 PM
    Join Date
    27 Nov 2010
    Age
    35
    Gender
    Male
    Posts
    485
    Threads
    97
    Credits
    0
    Thanked
    13

    Default

    Asalamualaikum!
    Shukria syar bhai.let me try this.Syar bhai ye formula B19 to B30 each cell main apply karun?ya just B19 main apply karun aor drag kar lun?

  11. #11
    syar is offline Advance Member
    Last Online
    Today @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    B19 m enter karain aur neche drag kar dain. Lekan Formula Lekhne/copy karne k bad "CTRL+SHIFT+ENTER" k sath enter karin.

  12. #12
    mugheez's Avatar
    mugheez is offline Senior Member+
    Last Online
    20th December 2016 @ 12:26 PM
    Join Date
    27 Nov 2010
    Age
    35
    Gender
    Male
    Posts
    485
    Threads
    97
    Credits
    0
    Thanked
    13

    Default

    Syar bhai thank you sooooooooooooooooooooooooooooo much for ur fully cooperation.Alhamdulillah ap ka bataya hua formula apply ho gaya hai and positions bhi sahi assign ho gai hain.
    ALLAH PAK ap ko bht asanian ata farmay!Aameen
    jazakALLAH!

Page 1 of 2 12 LastLast

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
  •