Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match & array
Hi,
I need help in setting up a formula that will compare two columns and return a count of cells in column A that are not in column B. Making this a bit more challenging, a cell beside it must meet a criteria. Example: assuming AB and CD are two period's worth of data Column A Column B Column C and Column D Carmen Dallas Carmen Dallas Jenny Houston Jenny Houston Mike Ohio Terry Ohio Terry Dallas I'd like a count of all those people in Dallas that are in column A, but are no longer in Dallas in column D How would it work? Thanks, Carmen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
match, lookup or array? | Excel Worksheet Functions | |||
1:1 as the Array using the MATCH function | New Users to Excel | |||
Match as well as does not match array function | Excel Discussion (Misc queries) |