Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
repeating data in column to empty cells below without overwriting jeffchina Excel Worksheet Functions 1 April 26th 07 05:50 PM
Delete Repeating text in cells Don B Excel Discussion (Misc queries) 2 September 3rd 06 10:24 PM
Repeating Characters in Cells with info. Stressed Student Excel Discussion (Misc queries) 3 December 8th 05 05:10 PM
repeating cells in footer in excel Dogu Tumerdem Excel Discussion (Misc queries) 0 August 3rd 05 09:20 AM
Linking a repeating pattern of non-adjacent cells wdg006 Excel Discussion (Misc queries) 2 December 14th 04 05:59 PM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"