Hi Guys,
Is it possible to have your formulas in a filtered view? I have formulas in place but, when I got to my filtered view. It says "#REF The Formula in cell AA18 is referencing a range in an active filter that is not in the same row". Been trying to look it up but, looks like it's not possible.
Is this true if not, can someone explain it or if their is a work around?
Would be greatly appreciated.
Warm regards,
Vilac
Bookmarks