Ranking without zero & ranking on multiple factors

Hi friends,

I am facing some problem with ranking formulae. Attached is a file illustrating them.

Problem 1: Ranking without zero
I have a set of data for products. They have a number next to it. Some of the products have a ZERO value next to them.
I want to rank the data in an ascending order while ignoring the products with ZERO value next to them.

Problem 2: Ranking on multiple factors
I have a set of data for 50 products.
There are 5 factors based on which I want to pick the best and the worst.
Each factor has a value which can be a negative number, zero or positive number.

This is what I am doing presently:
Ranking the products on each factor in a separate column.
Points are assigned based on the ranking, i.e. if the ranking of "product A" on Factor 1 is 32, then it gets 32 points
It is assumed that equal importance [weight] is given to each factor, thus average points is calculated based on ranking of each product on each factor.
Average points are again ranked in descending order
The top & bottom 10 are picked from this ranking

This is a lengthy process. Can someone help me do this in a better and shorter way keeping the following in mind....

Number of products and number of factors can be different for each analysis.
Presently I am giving equal importance to the rankings for each of the factors, what if I have to give varied importance [weight] to the factors.

Thanks always,

Hi

Problem 2? I don't follow what you trying to say?, there nothing say "product A" on Factor 1 is 32, then it gets 32 points when it say 0.00%??

Follow work

Cell L13

Formula:

Please Login or Register  to view this content.

copy down and cross to P column.

Cell S13

Formula:

Please Login or Register  to view this content.

copy down.

Cell U13

Formula:

Please Login or Register  to view this content.

copy down to row 10.

Cell U24

Formula:

Please Login or Register  to view this content.

copy down row 10.

Cell V13

Formula:

Please Login or Register  to view this content.

This is array formula? Press same time Ctrl+Shift+Enter, NOT ENTER, Then copy down to V33.

See the file!

Regard