Loop of Find

tiredofit

Well-known Member
Joined
Apr 11, 2013
Messages
1,109
Does anybody know if it's faster to loop through a column of data or use the Find method to look for a particular value?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,806
Office Version
365
Platform
Windows
I would suspect that find would be quicker.
But you could always write both & test their speed.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,806
Office Version
365
Platform
Windows
You're welcome
 

Forum statistics

Threads
1,085,693
Messages
5,385,220
Members
401,936
Latest member
stephenpoff

Some videos you may like

This Week's Hot Topics

Top