Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing/Matching two columns
Hi,
I am stuck with a problem. I need to compare two columns. one with ZIP and other with street names. A Single ZIP has numerous streent names. Is there a function which will say if the address is Right or Wrong? for example: 11000 Apple Street <Right 11000 Banana Street <Right 11000 Mango Street <Wrong and so on Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing & Stating The Nearest Matching | Excel Discussion (Misc queries) | |||
matching/comparing lists | Excel Worksheet Functions | |||
Comparing two columns and finding matching names | Excel Worksheet Functions | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |