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...
  • SergeiBaklan's avatar
    Aug 26, 2023

    mongoose20 

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

     

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

     

Resources