ExcelBanter - how do i select a column when using "exact" formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i select a column when using "exact" formula? (https://www.excelbanter.com/excel-discussion-misc-queries/134632-how-do-i-select-column-when-using-exact-formula.html)

JLEXCEL

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))

All times are GMT +1. The time now is 07:17 PM.