If a cell is equal to at least one of the column cells?

P

partyzanx2018-11-20 21:12:05

excel

partyzanx, 2018-11-20 21:12:05

I want to write the following formula
=IF(D2=O2:O2928, "1", "0")
Like if the content of cell D2 is equal to at least one cell from O2:O2928.
But it always returns 0, even though it's not true.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

P

partyzanx, 2018-11-20
@partyzanx

Helped
=IF(COUNTIF(O:O;D2), "1", "0")

Similar questions

S

Soul12021-09-28 18:50:51

How to insert data from the proposed list? 1Reply

V

Vladislav Aleinikov2018-07-13 13:46:37

Recording pictures in xls file cell without libraries? 0Reply

I

Ivan Danchuk2020-07-08 11:21:34

How to optimize file handling in Python? 2Reply

S

SLDY2021-10-07 11:23:40

How to add characteristics to a product through the standard Import in Prestashop CMS itself? 0Reply

N

Nikolai Shevtsov2015-05-27 18:07:17

How to defeat host mismatch with HP MSA1500 drive? 2Reply

Didn't find what you were looking for?

Ask your question