CODEWITHSUNDEEP
excelexcel-formula
Pavi Singh
Pavi Singh

Reputation: 1

Why Excel is showing this error when I try to do data validation

I am trying to do data validation in Excel and I've done it before but for some reason now this error is showing up. This is the error image

Here is the source table for it Source table

How can I fix this?

Upvotes: 0

Views: 4466

Answers (2)

Carlos M. Muñoz Ebratt
Carlos M. Muñoz Ebratt

Reputation: 11

When using "Lists" for data validation in excel spreadsheets, you must specify a range either horizontal (A1:J1) or vertical (A1:A10). This means you are not will be able to specify a "Matrix range" (A1:J10), and that is why the warning message says: "The list must refer to a single row or column (no a matrix).

Example of a wrong range selection: Example of a wrong range selection

Example of a correct range selection: Example of a correct range selection

Upvotes: 1

Tamir Rozenfeld
Tamir Rozenfeld

Reputation: 13

It means that the data validation list must be a one-way list (single column range or single row range), or a delimited list like this: A, B, AB, CD.

Range("A1:A10") Valid

Range("A1:D1") Valid

Hope it's helpful

Range("A1:C10") Invalid

Upvotes: 0

Related Questions