LinkBack URL
About LinkBacks
Hi guys,
I tried to rank a number of values and it worked with sumproduct. The problem is that some rows contain no value (or errors), so I wanted to rank only those with values.
A B Rank
1 Pepe 1 1
2 Pepe 2 2
3 Pepe N/A None
Please help.
Thanks!
Hi guys,
I tried to rank a number of values and it worked with sumproduct. The problem is that some rows contain no value (or errors), so I wanted to rank only those with values.
A B Rank
1 Pepe 1 1
2 Pepe 2 2
3 Pepe N/A None
Please help.
Thanks!
Last edited by huy_le; 03-18-2014 at 07:20 PM.
Try using COUNTIFS, e.g. this formula in C1 copied down
=IF(COUNT(B1),COUNTIFS(A:A,A1,B:B,"<"&B1)+1,"None")
Audere est facere
will this help
Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
I'm sorry, there will be names other than "Pepe", and I want to rank them separately. Like only rank for Pepe, and only rank for each of other people. Does that make sense?
Thank you but I don't think this will help because A will have values, only B will have some errors.
Originally Posted by judgeh59
Your formula works, just tested it now. Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks