I have a csv file which has multiple columns. The column headers are in row 1 and each column is called Scheduled or Actual.
In each column, there is a time record. I need an excel macro that will count the total number of Scheduled times and the total number of Actual times in the file. The result can be written to the end of the file as follows;
Scheduled Times: 40
Actual Times: 25
I have attached a sample file. In this file there are 40 Scheduled times and 25 Actual times.