Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
or(Exact) - problem
I'm trying to use the =OR(Exact) & compare a range of cells. Having
problems. It seems to work when the cells are in the same row, but not when comparing to cells in different rows in the range. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
or(Exact) - problem
Pl. see the reply in your other post under 'General Questions'
"markholt" wrote: I'm trying to use the =OR(Exact) & compare a range of cells. Having problems. It seems to work when the cells are in the same row, but not when comparing to cells in different rows in the range. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
or(Exact) - problem
It seems to work when the cells are in the same row
Enter the formula as an array. Array formulas are entered differently than a regular formula. After you type in a regular formula you hit the ENTER key. With an array formula you *must* use a combination of keys. Those keys are the CTRL key, the SHIFT key and the ENTER key. That is, hold down both the CTRL key and the SHIFT key then hit the ENTER key. When done properly Excel will enclose the formula in the brackets. You can't just type these brackets in, you *must* use the key combo. Also, anytime you edit an array formula it *must* be re-entered as an array using the key combo. -- Biff Microsoft Excel MVP "markholt" wrote in message ... I'm trying to use the =OR(Exact) & compare a range of cells. Having problems. It seems to work when the cells are in the same row, but not when comparing to cells in different rows in the range. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
== INSTEAD OF EXACT? | Excel Discussion (Misc queries) | |||
if / exact problem | Excel Discussion (Misc queries) | |||
if / exact problem | Excel Discussion (Misc queries) | |||
Getting an exact match | Excel Worksheet Functions |