I have a list of people, each who give a certain amount of X. Occasionally they receive a certain number of Y for their troubles.
I'm looking for a formula that will let me sort a list of people based on the ratio of X to Y.
In other words, if:
Jim gave 10x and got 1y
Sara gave 10x and got 2y
Chip gave 1x and got 0y, and
Deb gave 3x and got 2y
I need to be able to sort them Jim, Sara, Chip, Deb.
Part of the trouble I'm encountering here is the division by 0 for Chip. Does anyone have any nifty suggestions for a formula that I can apply to a list like this, but of about 50 people?
Thank you, in advance!