Software

Ask something
Discussion Locked

Excel Formula

0 helpful
7 replies

by nhoek

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to take for example 30 numbers in a column (which can change from time to time) and take the 6 highest numbers and put them into another column. Lets use column A and I want to put them into coumn B.

Is this possible?

7 replies

by dklippert

One way would be to use the LARGE() function.

=LARGE($A$1:$A$30,1)
=LARGE($A$1:$A$30,2)
=LARGE($A$1:$A$30,3)
etc.

by juniper

Or if not using unique cell referencing, simply key in =LARGE(A1:A21,1) the (A1:A21 is your range, the ,1) is simply saying put the highest item in here, and so on. If you are applying a sort to your data why not simply reference the cell to wherever you want the data to go!

by mariobnt

Yes it is possible.

Put your data in column "B"

Copy the formula =RANGE(B1,$B$1:$B$30)in column A

You will get in column A the range of each value in column B.

To obtain in column "C" the first "N" values of column "B" Top down, type this in C1:

= VLOOKUP(ROW(),$A$1:$A$30,2,0)

and copy in the next "N" Rows.

To have the reverse sequence just type ..(30-ROW(), ..

This discussion is closed to new replies.