Forum Discussion

Apie1975's avatar
Apie1975
Copper Contributor
Nov 03, 2021
Solved

Sorting dynamic array filter by date then by property number

Good morning
This is my first time asking for help please.

I am stuck on a dynamic array filter.

All data where it is pulled from is in date order but I need the filter to stay in date order but then if there is a second entry for the specific property number it must group them together. Please see current image. The two numbers on 3 November must just be together.
excel
Formulas and Functions
  • Yea_So's avatar
    Yea_So
    Nov 09, 2021

    Apie1975 

     

    Try this formula, (Don't forget to adjust the ranges before changing the name):

    =SORTBY(FILTER('https://crockersnz.sharepoint.com/Body Corporate/Portfolio Spreadsheets/Portfolio 1/[Crockers - Invoices .xlsx]Rep Nov 21'!$A$10:$V$49,ISNUMBER(SEARCH(LEFT('https://crockersnz.sharepoint.com/Body Corporate/Portfolio Spreadsheets/Portfolio 1/[Crockers - Invoices .xlsx]Rep Nov 21'!$U$10:$U$49,LEN('https://crockersnz.sharepoint.com/Body Corporate/Portfolio Spreadsheets/Portfolio 1/[Crockers - Invoices .xlsx]Rep Nov 21'!F3)),'https://crockersnz.sharepoint.com/Body Corporate/Portfolio Spreadsheets/Portfolio 1/[Crockers - Invoices .xlsx]Rep Nov 21'!F3))),'https://crockersnz.sharepoint.com/Body Corporate/Portfolio Spreadsheets/Portfolio 1/[Crockers - Invoices .xlsx]Rep Nov 21'!$C$10:$C$49,1,'Inv Nov'!$D$10:$D$49,1)

     

    Cheers

15 Replies

Resources