R
ronmcfarlane
Hi,
I am trying to put together a table to do some pair wise analysis of
some non functional requirements. The table has a list of columns and
an identical list of rows. At the intersection of each you can select
either the row name or the column name as being more important. I
would like to set up some validation on the cells to ensure that the
value is the column or row name from the intersection and nothing
else.
I attempted to put in the validation list a reference to the column
name and the row name seperated by a comma (=$B$1,$A$2) and I got an
error saying. "You may not use unions,intersections or array constants
for Data Validation criteria".
Any ideas on how to get arround this would be appreciated.
Ron
I am trying to put together a table to do some pair wise analysis of
some non functional requirements. The table has a list of columns and
an identical list of rows. At the intersection of each you can select
either the row name or the column name as being more important. I
would like to set up some validation on the cells to ensure that the
value is the column or row name from the intersection and nothing
else.
I attempted to put in the validation list a reference to the column
name and the row name seperated by a comma (=$B$1,$A$2) and I got an
error saying. "You may not use unions,intersections or array constants
for Data Validation criteria".
Any ideas on how to get arround this would be appreciated.
Ron