I have attached 2 sample workbooks.
The test-data.xls file is an older version of excel and cannot be changed to a newer version.
The data in range A2:H4 needs to be pasted as values into the range B5:I9 on the reporting workbook file, formula-test-sheet.xlsx. I have not changed anything and now when I paste the values into the report, the formula does not output the values in Column F, the Count column.
I am using Office 365.
Any help on this would be appreciated.
Thanking you in advance.
Bookmarks