Asslamo Alaikum!
Bohat khub Faisal bhai,
Ap ne MashAllah bohat acha silsla shuru kia hai,
thanks
ALLAH GIVES AND FORGIVES HUMAN GETS AND FORGETS
بہت اچھا سلسلہ شروع کیا ہے
AOA,
Faisal Bhai kya ap PIVOT TABLE k baray mein koi information share karain.
k ye k.say work karta hai or iska function kya hai ?
میرے دوستو گھر میں شادی کے فنکشن کی وجہ سے آپڈیٹ میں جو مشکل آ رہی ہے اس کیلئے میں معزرت خواہ ہوں
انشاٰاللہ بروز اتوارسے ریگولر اس کو شروع کروں گا
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!
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.
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 modify karna ho ga. agar aisa ho to bataye ga. Test itCode:=RANK(B2,$B$2:$B$35)
regardds
sohna kam a
Bookmarks