Hi all,
I have the following array formula to sort data (I cant use dynamic array because I need to run a formula off the results).
This formula works perfectly, but the range changes i.e. it isnt always down to row 66.
Formula:Please Login or Register to view this content.
As soon as there are less than 66 rows, the formula returns an error.
Does anyone know how to make it work so it will always work no matter how many rows are in the lookup?
Many thanks in advance,
Alex
Bookmarks