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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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