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.
May be this...
=COUNTIF(A:A,SUBSTITUTE(SUBSTITUTE(C2,".",""),"-"," "))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
hi cool_anu4u. i think you were referring to this post below where i provided the solution?
http://www.excelforum.com/excel-gene...ml#post3422754
but i didn't range up the entire column like you did here for TABLES!A:A. and i think you meant rows instead of columns. you could either do up a range big enough for your data like:
=ISNUMBER(LOOKUP(2^15,SEARCH(" "&TABLES!A1:A16000&" "," "&SUBSTITUTE(SUBSTITUTE(C2,".",""),"-"," ")&" ")))
or give us a sample data of your excel file to let us do the dynamic range. i provided a formula for that too in the other thread, but it might not be customised to your needs
If that takes care of your original question in that thread, you ought to select Thread Tools from the menu link above and mark thread as SOLVED too. Thanks.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks benishiryo , the problem was me ranging it up to the entire column.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks