Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 13th 08, 02:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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?

  #2   Report Post  
Old February 13th 08, 11:27 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 2,389
Default not allowing duplicates if 2 criteria are met

How are you controlling the entry of data? Macro? Manual input? We'll need
to know that before we can suggest a solution. Also, using colors to identiy
a condition is tough to check. Can you check for the condition which turns
the row red instead?

Regards,
Fred

"Kevin" wrote in message
...
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?


  #3   Report Post  
Old February 14th 08, 12:59 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 504
Default not allowing duplicates if 2 criteria are met

Fred, thanks for responding. I gave you bad examples for cell content. The
colors I spoke of are just words, so I should have said Smith, apple or
Smith, truck, etc..sorry about that confusion. I am currently using the code
"=COUNTIF($G$7:$G$36,G13)1" to check each row for duplicates, which works
fine. What I would like it to check for is if 2 criteria are met, not one. If
both criteria are repeated in the same column, it will give an error message.
I am using drop down lists for data entry. So, if Smith, apple is in row 13 &
14 for data, it wouldn't allow Smith, apple in 16 & 17 without returning an
error message, but it would allow Smith, truck. Hope that helps. Thanks
again, -Kevin

"Fred Smith" wrote:

How are you controlling the entry of data? Macro? Manual input? We'll need
to know that before we can suggest a solution. Also, using colors to identiy
a condition is tough to check. Can you check for the condition which turns
the row red instead?

Regards,
Fred

"Kevin" wrote in message
...
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?





Reply
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
Find duplicates in data with multiple criteria Danielle Excel Discussion (Misc queries) 1 December 14th 07 04:56 PM
Allowing Only Certain Entrees George Excel Worksheet Functions 3 September 25th 07 08:03 PM
Allowing a leading zero if there is one RontheWrench Excel Discussion (Misc queries) 2 June 26th 07 09:36 PM
Allowing for a range using COUNTIF desi Excel Worksheet Functions 2 January 25th 06 08:45 PM
Only Allowing Certain Codes In Column Buttercup Excel Discussion (Misc queries) 2 January 6th 05 10:32 PM


All times are GMT +1. The time now is 12:33 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017