Richard Drake
New Member
Members
Forum Posts: 2
Member Since:
October 30, 2021
October 30, 2021
Offline
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: 800
Member Since:
November 1, 2018
November 1, 2018
Offline
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen, Jordan Helman, Tracy Xie
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Kelsey Fennell
Jeffree Bunning
Jackie Memije
John Franzon
Darcie Clayton
trevor mir
Ruby White
Marisa Bradshaw
Eugene Augustine
MacNaughton Finance
Forum Stats:
Groups: 3
Forums: 24
Topics: 6872
Posts: 30122
Member Stats:
Guest Posters: 49
Members: 33668
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —