Forum Discussion

mongoose20's avatar
mongoose20
Icon for Microsoft rankMicrosoft
Aug 26, 2023
Solved

Choosing a range from a table

Here is an interesting puzzle:    Choose the first 10 rows of a table but not based on any criteria in the table. Not the top or bottom 10 based on a second column. We just want the the first ten...
excel
Excel on Mac
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 26, 2023

    mongoose20 

    If only one column range as in the sample for Solution 2,

     

    =TOCOL( TAKE(A1:A100,10 ),3 )

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 26, 2023

mongoose20 How about this?

=TAKE(Table1[#All],11)

It will return the headers plus the first 10 rows, or fewer if there aren't 10 rows in the table.

Or if you want to make it unnecessarily complicated:

=CHOOSEROWS(Table1[#All],SEQUENCE(MIN(ROWS(Table1),10)+1))

 

 

Resources