Thread: repeating cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default repeating cells

Hi, is it possible to have an error message pop up when info in a set of 2
cells repeats? For example, a2 & a3 contain Joe and apple. I'd like an error
to come up if that exact info comes up again in a5&a6, a8&a9, a11&a12, or
a14&a15. So basically, I don't want to be able to repeat the info in those
cells next to each other as shown. Also, I will be using drop down lists in
those cells if that changes anything. Thanks for any help.