Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel training seminar - small and large function

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - Small and Large Function

excel training seminar - Small and Large Function

ResolvedVersion Standard

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

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.