This formula is working as intended
=IF(D2=0,"",RANK(D2,$D$2:$D$31))
There is only a small issue ,
if two products have been sold same
quantity , it skips the next rank
Find attached , I don't want it to skip ,
is this possible , I have also put the
expected results too
this formula will break ties giving the first it finds the number then the second with the same value the next number. =RANK(D2,$D$2:$D$31,0)+COUNTIF($D$2:D2,D2)-1
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Not exactly because
It writes 7 and 8 rank for two products sold 10 total
I need it to write 7 and 7
that is what I get for reading your post but not looking at your data. sorry.
this looks like it might work but it is a 3 step process (see this link for more) http://answers.microsoft.com/en-us/o...9-bc8d36eed450
here is your attachment back with it in columns I, K and L
This is beautiful , it will work ,
I will hide step 1 and step 2 with column width zero
Thank you very much
Sambo its working on limited data ,
here is the complete data for
someone to try out
Attached the file
If there will be need of help columns ,
let the main formula be on cell C2 where
my current rank formula is
Last edited by makinmomb; 06-07-2014 at 12:13 AM. Reason: grammar
Anyone maybe , does is sound not possible
Hi
Do you mean you want to look like this Rank 7, 7 then 8 instead lump to 9?
If yes Cell C2Copy downFormula:
Please Login or Register to view this content.
Regard
micope21
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
makinmomb, sorry but off site for a while. looks like micope21 gave you an answer that works. thank you for the feedback and don't forget to thank him if his ans worked.
Pl see attached file with one more approach.
Try this Array Formula which requires confirmation with Ctrl+Shift+Enter.
and drag down.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Micope this is it ,
I picked the non array formula of yours
Thank you very much
You welcome! Thank you for stars.Originally Posted by makinmomb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks