Dear Souza, Pl see the attached data is it ok?
Warm Regards, Gawli Anil On Fri, Jun 14, 2013 at 12:00 AM, Thiago Souza <souza...@gmail.com> wrote: > I need to validate an information like this****** > > ** ** > > __A____B_C**** > > Name 1 w w ....**** > > Name 2 w w .... **** > > Name 3 o o ....**** > Name 1 o w > Name 2 w w** ** > > so I need to do a conditional format showing (color or text box) the user > that he can't use "w" again to "Name 1" or "Name 2", becouse he already > chose "w" before and he can't choose again, for either column from B to L > and lines 1 to 5 for example. **** > > ** ** > > I thought use a data validation using countif with lookup, but i couldn't > make it. I'm trying to write VBA right now, but I still think there is a > easier and simpler way! (I'm storing the first name and running a loop to > compare if there is another equal name then check if there is the same > entry on the same column.**** > > ** ** > > ** ** > > ** ** > > Thank you**** > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
data validatio_P.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
