| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search range for text not in another range
I want to find all cells in column A that do not have an identical matching
cell in column C. Ideally I'd then like to list these in column D. Columns A and C only contain text. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search range for text not in another range
Assuming your first data line starts in cell A1, in column D1 use the formula
=exact(A1,C1). This will return a true or false value. "simon howard" wrote: I want to find all cells in column A that do not have an identical matching cell in column C. Ideally I'd then like to list these in column D. Columns A and C only contain text. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search range for text not in another range
Thanks Reneets for your quick reply - I should have made it clear that the
matching cell in column C could be anywhere in that column (which is a subset of the data in col A). Your formula only compares A and C cells in the same row. Anyway, I've now found the solution: In column D (D2:D538) I copied =VLOOKUP(A2:A$538,rangename,1,FALSE) which placed the col A value where it matched exactly and #N/A everywhere else. "reneets" wrote: Assuming your first data line starts in cell A1, in column D1 use the formula =exact(A1,C1). This will return a true or false value. "simon howard" wrote: I want to find all cells in column A that do not have an identical matching cell in column C. Ideally I'd then like to list these in column D. Columns A and C only contain text. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search range for text not in another range
Oops..it's slightly simpler:
=VLOOKUP(A2:A2,rangename,1,FALSE) "simon howard" wrote: Thanks Reneets for your quick reply - I should have made it clear that the matching cell in column C could be anywhere in that column (which is a subset of the data in col A). Your formula only compares A and C cells in the same row. Anyway, I've now found the solution: In column D (D2:D538) I copied =VLOOKUP(A2:A$538,rangename,1,FALSE) which placed the col A value where it matched exactly and #N/A everywhere else. "reneets" wrote: Assuming your first data line starts in cell A1, in column D1 use the formula =exact(A1,C1). This will return a true or false value. "simon howard" wrote: I want to find all cells in column A that do not have an identical matching cell in column C. Ideally I'd then like to list these in column D. Columns A and C only contain text. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
| Sumproduct (Range unknown, needs Search) | Excel Worksheet Functions | |||
| How to use an index number in a search range | Excel Worksheet Functions | |||
| how do you search a range of cells... | Excel Discussion (Misc queries) | |||
| How do I get excel search through a range of numbers e.g. 1.99 - . | Excel Worksheet Functions | |||
Hybrid Mode
