Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking query
Hi
I would like to know if it's possible to change RANK so that it doesn't increment if it finds duplicates, ie, all the duplicate highest ranks are 1 , then no matter how matter how many there are all the next highest numbers will be 2, etc. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking query
Hi
with your numbers in column A1 down put this in b1 and asjust the a100 to the length of your range and drag down =SUMPRODUCT(--(A1A$1:A$100),1/COUNTIF(A$1:A$100,A$1:A$100&""))+1 Mike "Marie Bayes" wrote: Hi I would like to know if it's possible to change RANK so that it doesn't increment if it finds duplicates, ie, all the duplicate highest ranks are 1 , then no matter how matter how many there are all the next highest numbers will be 2, etc. Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking query
Hi Mike H
That's great thanks, I just swapped the for a < to get my ranking in the right order, but it's working - thanks again. -- Marie Bayes "Mike H" wrote: Hi with your numbers in column A1 down put this in b1 and asjust the a100 to the length of your range and drag down =SUMPRODUCT(--(A1A$1:A$100),1/COUNTIF(A$1:A$100,A$1:A$100&""))+1 Mike "Marie Bayes" wrote: Hi I would like to know if it's possible to change RANK so that it doesn't increment if it finds duplicates, ie, all the duplicate highest ranks are 1 , then no matter how matter how many there are all the next highest numbers will be 2, etc. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |