Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Most efficient way to search a range
Hey Ken if you post your existing code it would be more helpfull for others
to improve it for you Dan Thompson "Ken Warthen" wrote: I have a named range with eight columns and 3700 plus rows. I need a fast and efficient manner of searching for all incidents of a given name in column E and return the values of column B for each row where a column E value matched the search name. I've kludged some code that works, but it's takes way too long to return results. Any help or direction would be greatly appreciated. Ken Warthen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Efficient Source Range | Excel Discussion (Misc queries) | |||
most efficient large range summing? | Excel Programming | |||
more efficient way to lookup a range? | Excel Discussion (Misc queries) | |||
Efficient STRING search with SpecialCells | Excel Programming | |||
Efficient Search / Find | Excel Programming |