One more question:
I'm going to set this up in a template to sort material lists. Some of the lists have thousands of entries, whereas others only have a hundred or so. Is there a way to adjust the endpoint of the array so that it automatically detects where the list ends instead of me having to manually manipulate it?
For example:
For the first list I am sorting to A45, but the second list only goes to A20. If I import the 19 item list into the table I get a #VALUE error unless I adjust the formula to read
Is there a way to set it up for 4,000 entries ($A$4001) but have it autodetect if the list does not extend that far?
Bookmarks