I would like to create a sheet that can give me a weighted score at the end
of the row.

What I mean by this is I have a sheet with 4 colums and 10 rows,

each of the rows will have a weighted number in each of the colums with a
total at the end.

With out sorting the rows I would like to rank them in importance, the
highest number being a 1 the next a 2 the next highest a 3 and so on. Is
there a function that does this or does someone have a formula?

Thanks