Calculating percentage drops in a column of numbers using the Small command
Posted on 2013-06-20
I have a column of numbers (column A), a sample of which is below. What I need a to calculate in a single cell (B1) is the largest percentage drop from any given value to the lowest subsequent value. I can easily do this using another column to calculate the percentage drop, but I want to do it within one cell. I want to use Small so I can cput the second largest drop in cell B2, etc. Is this possible?
Here's the sample data:
1000 -5.66% (from 1060 to 1000)
1025 -5.58% (from 1165 to 1100)