Compiling and sorting a table at the same time

excelos

Well-known Member
Joined
Sep 25, 2011
Messages
505
Office Version
  1. 365
Platform
  1. Windows
Hello

I have a table (not formatted as table) that the first column is an array formula and the other columns are formulas calculating on the first column.
Whenever the data changes and the first column array length changes, I re-fill the formulas of the other columns so that the table is complete.

I want to always sort this table in a specific way. To do that, I now compile the table in one area of the spreadsheet and then I use SORT and repeat the table in another area of the spreadsheet which is the final format that I will be using.

Is there a way to eliminate this 'helper table' step and compile and sort the table in one place in the spreadsheet? But I need not to make the formulas too big. (I was thinking to create the table with a SEQUENCE formula and then nest this in a SORT formula but I reckon it will be too big)

Thanks!
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
73,214
Office Version
  1. 365
Platform
  1. Windows
You are more likely to get help, if you
1) Provide some sample data using the XL2BB add-in, that shows your original data.
2) Provide the formula you are currently using & the results they give.
3) Show what you want as the final outcome.

So far you have just given us nothing to work with.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,043
Messages
5,835,099
Members
430,341
Latest member
kelstnmate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top