sorting cells in excel into specific columns

p45cal · #4 05-10-2022, 01:27 AM

For just those two columns, and if you have O365 with the LET and SEQUENCE functions, then in any single cell:

Code:

=LET(rng,Sheet1!A1:A100,INDEX(INDEX(rng,SEQUENCE(ROWS(rng)/4,4)),SEQUENCE(ROWS(rng)/4),{1,3}))

and if this is on the same sheet there's no need to refer to the sheet name:

Code:

=LET(rng,A1:A100,INDEX(INDEX(rng,SEQUENCE(ROWS(rng)/4,4)),SEQUENCE(ROWS(rng)/4),{1,3}))

These formulae will spill down and across so make sure there's nothing in those cells else you'll get #SPILL! in the cell with the formula.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I transfer specific data from email to specific excel cells?	Mauro	Outlook	1	11-11-2019 09:17 PM
Linking Specific text fields in PP to specific cells in an Excel table	GWRW1964	PowerPoint	0	02-26-2018 07:37 AM
Linking cells: can sub-cells move with their master-cell when sorting?	kw01	Excel	1	06-30-2015 05:02 PM
Macro to copy specific columns in Excel from another spreadsheet	KD999	Excel Programming	1	07-20-2012 08:58 AM
Sorting columns in Excel - please advise	Jonre	Excel	2	08-21-2009 02:38 AM