in column G, i have a list of values. how would i go about ranking cell G2 with all the column cells in G, all the cells in L, and all the cells in Q?
meaning: if G2 has 1 cell higher in G:G, 1 cell higher in L:L, and 0 cells higher in Q:Q, it will return 3 as the rank
sample.xlsx
edit: attachment added
Last edited by kamelkid2; 11-29-2012 at 08:54 AM.
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
attachment added
is my solution. i had to add and change some columns around, but basically it will count the number of occurrences that a value is greater than the cell of interest in all the applicable columns, and then add 1 to count for itself
=COUNTIF($J:$J,">"&J2)+COUNTIF($Q:$Q,">"&J2)+COUNTIF($X:$X,">"&J2)+COUNTIF($AE:$AE,">"&J2)+COUNTIF($AK:$AK,">"&J2)+COUNTIF($AQ:$AQ,">"&J2)+COUNTIF($AW:$AW,">"&J2)+COUNTIF($BC:$BC,">"&J2)+1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks