Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 451
- Office Version
- 365
- Platform
- Windows
I have this array and as you can see I have 3 sorts, is it possible to sort only from row 12 because I want Row 11 to still come in with the array but to stay at the top roe.
This is my formula =SORT(SORT(SORT(FILTER(CHOOSECOLS('Data Analysis'!$G$11:$FK$1000,1,2,5,6,3,4,28,7,8,9,10,11,12,13,14,23),'Data Analysis'!$G$11:$G$1000<>""),2),3),5)
Any help would be appreciated.
This is my formula =SORT(SORT(SORT(FILTER(CHOOSECOLS('Data Analysis'!$G$11:$FK$1000,1,2,5,6,3,4,28,7,8,9,10,11,12,13,14,23),'Data Analysis'!$G$11:$G$1000<>""),2),3),5)
Any help would be appreciated.