[Solved] I cant use Item specifier i.e #All and #Headers

Mike_Vu_Ngo 

HansVogelaar has correctly identified your problem; I was simply suggesting a check for possible typing errors.

From what you describe, your wife's laptop has Excel 365, which treats arrays correctly.  Traditional spreadsheets (up to and including 2019) intentionally reduce an array reference to a single cell that happens to be in the same row or column as the formula cell; hence the need for 'and fill down' with each copy of the formula returning a single value.

I used to use CSE arrays or write the formulas as defined Names to avoid traditional spreadsheet behaviour but practically all other users see the cell-by-cell processing as wonderful in its simplicity.  Oddly, they do not appreciate my describing the result as a 'steaming pile of junk'.