Formula for Counting Days/Orders

  • Re: Formula for Counting Days/Orders


    In F5:


    =INDEX(Orders[Date],MATCH(MAX(COUNTIFS(Orders[Date],Orders[Date],Orders[Day],Tabelle3[[#This Row],[Day]])),COUNTIFS(Orders[Date],Orders[Date],Orders[Day],Tabelle3[[#This Row],[Day]]),0),)


    confirmed with CTRL+SHIFT+ENTER not just ENTER, then copied down


    in G5:


    =COUNTIF(Orders[Date],Tabelle3[[#This Row],[Date with most orders:]])


    confirmed with just ENTER and copied down

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!