SORT FUNCTION FOR SORTING DATA IN ROWS IN A TABLE

Question

Hello! I have the table below on the left that I need to sort all of the expiration dates for. The expiration dates are in Columns B through F. I need the earliest dates to the left.

Using the SORT function I have figured out how to do this, as you can see in columns H through L. I put the function: =SORT(Table3[@[DateA]:[DateE]],,1,TRUE) into cell H1 and then I drag this down through the cells below it in Column H and I get the results that I want.

The problem is that this table on the left can have over 10,000 rows, and I would like for the SORT function cells to be included in the table. When I attempt to add this function to the table, I get a SPILL.

Is there a way that I can overcome this? Thank you!!!

Answer 1

I'm afraid you cannot use dynamic array functions such as SORT or FILTER inside a table. a table cannot handle spill areas.

You'll have to convert the table to a normal range, or keep the formulas outside the table.

Answer 2

Okay thank you Hans!