Hello,
I'm using this array formula
=ISNUMBER(LOOKUP(2^15,SEARCH(" "&TABLES!A:A&" "," "&SUBSTITUTE(SUBSTITUTE(C2,".",""),"-"," ")&" "))) (courtesy: benishiryo).
for a set of data of 15000 columns . Can any one suggest an alternative for this so that it calculate faster.
Bookmarks