How to make multiple columns in COUNTIF?

O

oleg182132019-07-11 23:24:47

Google Sheets

oleg18213, 2019-07-11 23:24:47

I want to prevent duplicate values across multiple columns. I have a forum "=COUNTIF($A:$B;"="&B10) < 2" which only works for columns A and B. How can I make it work for other columns?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

dollar, 2019-07-12
@dollar

=СЧЁТЕСЛИ($A:$B;B10) + СЧЁТЕСЛИ($Z:$Z;B10) < 2

Similar questions

D

dianadida2021-11-04 18:47:37

How to create an edit access control in Google Sheets? 1Reply

Y

yurafresh2018-08-20 14:30:58

How to export sales from Woocommerce to tables? 2Reply

D

da32021-11-15 19:43:09

How to import rows according to certain criteria with the addition of a trigger? 1Reply

P

pilityxxx2020-08-10 15:19:42

How to write all values from column B of google spreadsheets to a list in Python? 1Reply

P

PILITYXXX1232020-08-10 22:02:33

How to convert from 3 columns of google spreadsheets to 1 column in python? 1Reply

Didn't find what you were looking for?

Ask your question