| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i select a column when using "exact" formula?
It comes up with #NUM! When I use "H:H" p.s. this is in an array, and i did
do the Ctrl+Shift+Enter. The formula is =OR(EXACT(C2,H:H)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
| match true exact "dd" vs. find next 5th character=y | Excel Discussion (Misc queries) | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| Questionnaire sheet: Select "yes" or "no," and only one can be selected | Excel Worksheet Functions | |||
| Can you replace "TRUE" with " " in an exact formula? | Excel Worksheet Functions | |||
Linear Mode
