| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using exact formula to compare cells
I'm trying to compare the values in two columns by using this formula
{=OR(EXACT(B3, $A$2:$A$394))} however, it does not seem to be picking up when the cells contain the same information. It just returns a FALSE answer. -- Garry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find cells containing exact text, and separate them | Excel Worksheet Functions | |||
| Compare Two Columns (Exact and Wildcard) | Excel Worksheet Functions | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| How do i compare numbers in cells with formula | Excel Discussion (Misc queries) | |||
| How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
Threaded Mode
