dear friends asalam-o-alaikum
i need your kind help to complete that sheet
is mein mujhe obt wali figure se jo bari figure ho us ko select krne ka formula required hein
dear friends asalam-o-alaikum
i need your kind help to complete that sheet
is mein mujhe obt wali figure se jo bari figure ho us ko select krne ka formula required hein
please koi to check kru
Is ke liye yaqeenan filters use krain aur aap apne sawal ko describe krain mazeed takay help ho sakay
Kya aap apni bat zara mazeed explain karain ga.Ap ne kaha obtain se bari figure select karni ha. Kis range me sa. Kia aap range bata sakte hain ya column ka bata sakte hain k kis column me sa chaheye. Aap ki bat pori samajh nahee aae. Dosra aap na jo formula lagaya ha is m mujhe Large, Max, average ki samajh nahee aae ka aap ya kis leye lagana chahte hain. aap apne Average large ka formula ko is se replace karain tu aap ko index number ki zaroorat nahee pare ga aur neeche tak copy kar dain.
App zara detail m explain karainCode:=LARGE($N$10:$N$33,ROW(A1))
regards
thanks SYAR BAHAI AP NE MERI PROBLEM SOLVE KR DI HEIN
BUT AIK CHEEZ KI MUJHE SAMAJ NAHI AYI
AP KE FORMULA MAIN
=LARGE($N$10:$N$33, ROW(A1))
rOW(A1) YEH KIA HEIN
KINDLY EXPLAIN THANKS FOR HELP
salam,
=Row () ,row number return karta ha. Yani agar aap row a1 m agar aap lekhain tu ye 1 return kare ga agar a3 m lekhain tu 3 return kare ga.
Large function ko execution ka leye 2 argument darkar hote hain. 1 array aur 2 kth number. Array se murad aap range le sakte hain. Jabka kth number se murad ha ka aap konsa bara number return m chahte hain, yani pehla tu aap 1 lekhain ga agar 12 return me chaheye tu 12 lekhain ga.
Ye mumkin nahee hota ha k aap har row m kth number k leye 1,2,3, lekhain. Is masla ko hal karne k leye kth number ko hum =row() ka function se change kar dete hain. Liken masla maze asan karne ke leye is me =row(a1) yani row ka number dalte hain k row ka function 1 return kare. Aur neche jab copy karte hain tu a1 a2,a3 se replace ho kar 2,3, generate karta ha. Jo ka large k function ko matlooba kth number muhaya kar deta ha.
Umeed ha ka aap ko thoda bohat samjh aa gaya ho ga. Aap row k function ko try karain tu khod understand kar lain ge.
regards
Thanks alot
[FONT="Jameel Noori Nastaleeq"][CENTER][COLOR="Blue"][SIZE="5"][B]Coming Soon...:)[/B][/SIZE][/COLOR][/CENTER][/FONT]
Bookmarks