Yanti has attended:
Excel Advanced course
Small and Large Function
Hello,
I have a few long lists with items to be ranked from the largest the smaller. But they are so big that if I manually changed the rank number (k) in the formula it would take forever.
Is there a way to drag down the cell with the formula and automatically have the "k" numbers update from 1 to.....400?
Formula =LARGE(array,K)
RE: Small and Large Function
Yes, there is a simple way to do that.
Instead of having a static number for (k), you can make it a cell reference.
So have another column next to your LARGE calculation, which has the (k) variable in it. you can use the Fill series to create this very quickly.
Then you simply point the argument in the Large or Small function (k) to that cell.
See attachment for an example.
Richard