Hi...
I have an array formula to get the top 10 products in a product list.
Please Login or Register to view this content.
The issue is column AB pulls product names from another sheet. And on that other sheet if row 5 is deleted it throws the #ref error.
Is there a way to change this formula to an offset or something so it won't #ref error in rows are deleted in the other sheet?
Thank you for any help.
Bookmarks