G
Guest
Guest
I have a spreadsheet with a list of some 5000 products with each product having a ranking between 1 and 5000 under 3 criteria as follows:
A B C D
Product GP Rank Units Rank COGS Ranks
12345 221 5 281
23456 3 1234 17
45678 4231 2567 3214
I want a formula for column E which says if the ranks in columns B,C & D are within range 1-300 then this is a gold product, if the ranks for any 2 of the columns is within range 1-300 then silver, if the rank for only 1 column is within 1-300 then bronze otherwise grey. The result of the proposed formula in column E in the above example would be:
12345 Gold
23456 Silver
45678 Grey
Hope this makes sense and hope someone can help.
Thanks
Bob
A B C D
Product GP Rank Units Rank COGS Ranks
12345 221 5 281
23456 3 1234 17
45678 4231 2567 3214
I want a formula for column E which says if the ranks in columns B,C & D are within range 1-300 then this is a gold product, if the ranks for any 2 of the columns is within range 1-300 then silver, if the rank for only 1 column is within 1-300 then bronze otherwise grey. The result of the proposed formula in column E in the above example would be:
12345 Gold
23456 Silver
45678 Grey
Hope this makes sense and hope someone can help.
Thanks
Bob