
Richard Drake
New Member
Members

Forum Posts: 2
Member Since:
October 30, 2021
October 30, 2021

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.

Velouria
London or thereabouts
Moderator
Members

Trusted Members
Moderators

Trusted Members
Moderators

Forum Posts: 689
Member Since:
November 1, 2018
November 1, 2018

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Mynda Treacy, Barbara Murray
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Forum Stats:
Groups: 3
Forums: 24
Topics: 6544
Posts: 28650
Member Stats:
Guest Posters: 49
Members: 32831
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
