Hello,
I am using an array formula to generate a unique list, which looks like: {=INDEX(Sheet1!$A$3:$A$3010, MATCH(0, COUNTIF($B$3:B48, Sheet1!$A$3:$A$3010), 0))}
The issue though is that it causes some lag when editing the cells it is referencing.
Is there another way to write this so that it doesn't add latency when inputting data?
Thank you,
Kanuck
Bookmarks