Thread: Data validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ian c ian c is offline
external usenet poster
 
Posts: 2
Default Data validation

I have a table of 5 columns the cells in each column refer to a drop down
list (so there are five different lists) i want to prevent more than one of
the five cells being picked if that makes sense so in any one row if you have
picked from the drop down list in one cell you are prevented form doing the
same in any of the other four. hope that makes sense.