Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding values quick
hello
i have a sheet (one) with about 4000 rows of values, in colom A there are 35 possible values and in colom B 700 possible values. combinations can appear multiple times In a second sheet i have colom B with the same 700 values as in colom B of sheet one, and in colom A for each of these 700 values one of the 35 possible values. The 700 values are unique in this sheet. Now i need to examen these 4000 rows and compare each value in colom B with the same value in the second sheet colom B, if these match i need to check if the values in the A coloms are the same. I have this running with brute force FOR NEXT loops, but it take about 20 minutes to complete. Does anybody have an idea how to speed it up. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide 0 values in quick access toolbar (Excel 2007) | Excel Worksheet Functions | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
Finding values | Excel Worksheet Functions | |||
finding values and displaying adjacent values | Excel Worksheet Functions | |||
Finding Max values | Excel Worksheet Functions |