I have a data extract that contains the raw data from a helpdesk system. I am trying to create a new spreadsheet that will count various elements of data from this extract, I understand that I can use the DCOUNT function but only if the original extract is open.
Is there a way of counting data in a closed workbook?
Any advice appreciated.
Is there a way of counting data in a closed workbook?
Any advice appreciated.