Thread
:
Help in ranking Formula
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_4_]
external usenet poster
Posts: 57
Help in ranking Formula
Hello George,
Assuming your Production figures are in A2:A15 and percentages in
B2:B15 then try this formula in C2 copied down
=SUMPRODUCT(--(B$2:B$15+A$2:A$15/10^9B2+A2/10^9))+1
Reply With Quote
barry houdini[_4_]
View Public Profile
Find all posts by barry houdini[_4_]