View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default not allowing duplicates if 2 criteria are met

Hi, I am trying to find a way to limit entries based on 2 criteria. For
instance, if column A, row 13 is Smith and row 14 is red, it won't allow
column A row 16, Smith and row 17 red, but it would allow Smith, Blue.
Basically, I want to fill 2 cells with info and not have both cells repeated
somewhere else in that row. The 2 rows will always be in numerical order by
the way. Is this possible?