Forum Discussion

Excel's avatar
Excel
Iron Contributor
Aug 11, 2022
Solved

Query related to excel formula

Hello Everyone,   Here's the context: data is filled into a spreadsheet every day. I want to have it so in the end of it, all that has to be done is update the text in a cell, and the 'database' ar...
  • HansVogelaar's avatar
    Aug 11, 2022

    Excel 

     

    Use

     

    =DCOUNTA(INDIRECT(TEXT($H$4,"mmmmdd")),4,K3:M4)

Resources