I want to copy and paste only pass student with highest to lowest marks in rank to another worksheet. How can I solve it? Your suggestion will be highly appreciated.
Indra
I want to copy and paste only pass student with highest to lowest marks in rank to another worksheet. How can I solve it? Your suggestion will be highly appreciated.
Indra
try like this
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Exactly the same question 7 months later?
=IFERROR(INDEX(Sheet1!A$2:A$1000;SMALL(IF(Sheet1!$L$2:$L$1000="Pass";ROW(Sheet1!A$2:A$1000)-1);ROW(Sheet1!A1)));"")
And as this Array formula does not gives you the results from Highest to Lowest, use this one to give the rank and then use Custom Format according this column.
=IF(J2="";"";RANK(J2;$J$2:$J$20))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you once again Fotis1991,
But I don't want to just their rank but also want to list all row data ranking from descending order according to total marks.
Indra
Did you see my example sheet? Does exactly this...
Thank you very much martindwilson, I want to list descending order by marks. Please suggest.
Indra
Please find a sample file for your kind reference.
Thank you..
Indra
...............................
Dear Fitis1991,
Thank you very much for your kind cooperation.
Yes, you are right but I still want to another one thing that sorting automatically according to range, when I change the marks. Please find attached herewith a sample file..
Indra
Try this
A2
Committed with CSE.Please Login or Register to view this content.
See attached file.
HTH,
WindKnife
Dear windknife,
Thank you so much for your kind cooperation. You are genius. It works perfectly.
Thanks one again.
Indra
Indra why did you not just change LARGE to SMALL in the sample i gave you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks