Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Try something like this: Define your ZipCodes as a Named Range - "ZipCodes" Define your Employee ZipCodes as a Named Range - "EmpZips" Then run a nested For-Next loop For Each C in Range("EmpZips") For Each D in Range("ZipCodes") If c=d then 'Found a match - Do something" 'Then jump to the next Employee Exit For End If Next D Next C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing two data sets | Excel Worksheet Functions | |||
manipulating large data sets for graphing | Excel Discussion (Misc queries) | |||
Comparing two sets data for different month | Excel Discussion (Misc queries) | |||
how to save large data sets in excel | Excel Discussion (Misc queries) | |||
Comparing two sets of data | Excel Programming |