Forum Discussion
Need formula help
We have a workbook with a sheet for each month named Jan - Dec. on each sheet is the date in column A and column B, C, D have text data and column E has numbers. What i need is a formula that gives ...
Stack, sort, and take:
=LET(
dates, VSTACK(Jan:Dec!$A$2:$A$100),
amt, VSTACK(Jan:Dec!$E$2:$E$100),
M, SORT(HSTACK(dates, amt), 2, -1),
TAKE(M, 1)
)The above solution utilizes a 3D reference.
Create a 3-D reference to the same cell range on multiple worksheets - Microsoft Support
Since you have a date column, another option might be to consolidate the information in one sheet then the analysis becomes easy and there's no need to stack the data.