Forum

Index function to r...
 
Notifications
Clear all

Index function to return entire rows

4 Posts
2 Users
0 Reactions
94 Views
(@dicken)
Posts: 2
New Member
Topic starter
 

Hi all,

I've been experimenting with index and match ; INDEX(F5:J16,4,0)

and more important  NDEX(C3:G14,SEQUENCE(ROWS(C3:C14)),0)

The first when using 0 for the column will return the entire row, which is what I want, the second formula returns all the rows which is what I want but only  only returns the first column? and I want them all.

I can use a curly {1,2,3,4 etc} to get all the columns, but this is not great.  nor dynamic.

Please don't suggest filter functions because that's not the point.  I'd like to sovle the problem.

I've attached the workbook I've been using ; sheet 1 better example.

Richard.

 
Posted : 02/11/2021 9:10 am
(@debaser)
Posts: 836
Member Moderator
 

You need an array for the columns too, so you could use another SEQUENCE function.

 
Posted : 02/11/2021 10:20 am
(@dicken)
Posts: 2
New Member
Topic starter
 

Thanks I'll try that.

RD

 
Posted : 03/11/2021 8:10 am
(@debaser)
Posts: 836
Member Moderator
 

I'm assuming there is more to this question because if you want all the rows and all the columns, you don't need INDEX at all: just use =C3:G14

 
Posted : 03/11/2021 8:33 am
Share: