Forum Discussion

Copper Contributor

Jun 22, 2023

=FILTER function and cells: empty array error?

I'm having some issues with the =FILTER function on Excel MAC version (16.74). A really annoying one is that it does not work with cells (like A2 instead of a word or a number). It comes back with th...

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Jun 22, 2023

FrancoiseM The FILTER function works exactly the same on a Mac as on a PC. So, can you show exactly how you are using the function? A screenshot showing the formula and the cells/ranges it references. Or better to share a link to a file on Onedrive or something similar, demonstrating the issue.

FrancoiseM
Copper Contributor
Jun 22, 2023
Riny_van_Eekelen
I realised it was not a MAC issue after sending this message and trying our online 365 version, same problem which is reassuring in a way. An annotated version of the file is at:https://www.dropbox.com/scl/fi/el7r5j3f0uzu8hijrtbgj/for-correction-copy-2.xlsx?dl=0&rlkey=nlmmfgd57fhk8lg8heztbjizh
Thank you !
- Riny_van_Eekelen
  Platinum Contributor
  Jun 22, 2023
  FrancoiseM See attached. Google on "structured table references in Excel" to learn more about them and see if you can apply 'my' formulas to you real life situation.
  for correction copy 2.xlsx48 KB
  - FrancoiseM
    Copper Contributor
    Jun 22, 2023
    Thanks for that, it clearly works on your spreadsheet but when I copy the formula to my real life document, changing only the cell "coordinates" (manually or by clicking on it) it still doesn't work and comes back with CALC error message. Maybe something is corrupted somewhere (there are several tabs, and other data being collected on the dashboard...) I think I'll have to start from scratch and rebuild the document bit by bit.

Resources