Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 451
- Office Version
- 365
- Platform
- Windows
I'm currently getting an array from this formula
=UNIQUE(CHOOSECOLS(FILTER('User Analysis'!$G$12:$AG$1000,'User Analysis'!$G$12:$G$1000<>""),1,2,3,4,10,20))
In Column C (Text) (which is column 3 from the choose columns feature)I want to add to this formula to make it sub total all value columns (10 and 20) at each break point in Column C
Is this possible
=UNIQUE(CHOOSECOLS(FILTER('User Analysis'!$G$12:$AG$1000,'User Analysis'!$G$12:$G$1000<>""),1,2,3,4,10,20))
In Column C (Text) (which is column 3 from the choose columns feature)I want to add to this formula to make it sub total all value columns (10 and 20) at each break point in Column C
Is this possible