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!