Re: Data Validation Formula Q

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Think you could try:
=OR(AND(J10>=1,J10<999999,COUNTIF($J10:J22,J10)=1),J10="CC")

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Seanie" <seanryanie@xxxxxxxxxxx> wrote in message
news:92be3ea9-9c66-4e8f-b190-f82c98476449@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
How could I tweak the Data Validation below which in cell J10 where it
resides, also include an ability to enter the letters CC?

At the moment it requires up to a 6 digit numeric value which must be
unique from the inputs in J10:J22. I still want to retain this but
also allow the letters CC. Note here I want to allow CC to be typed in
more than one cell in the range J10:J22 (but the up to 6 digit
numerics must be unique)

=AND(J10>=1,J10<999999,COUNTIF($J10:J22,J10)=1)


.

Relevant Pages

  • Re: WAYTTGOPTLTL? (Brahms)
    ... the following letters to be typed in ... or "tune"? ... lost the ability to listen to music as music. ...
    (rec.music.classical.recordings)
  • Re: Conductors who have defined the interpretation of a work
    ... bzukerman@xxxxxxxxxxxxxx appears to have caused the following letters to be ... Furtwangler has virtually ruined my ... ability to enjoy any other conductor's version. ... Matthew B. Tepper: WWW, science fiction, classical music, ducks! ...
    (rec.music.classical.recordings)
  • Re: Christian TV Available for All
    ... I got two video recorders for NWTV and promptly had letters and a ... I thought just "having the ability to receive" counted, ... It's a licence to receive. ...
    (uk.religion.christian)
  • Re: Is Tom Deacon OK? (was Re: NYT: Appreciating Brendel at 75)
    ... Allen appears to have caused the following letters to ... believe which quite possibly says it all really both as to his ability ... My personal home page -- http://home.earthlink.net/~oy/index.html ... do for my address what Androcles did for the lion ...
    (rec.music.classical.recordings)
  • Data Validation Formula Q
    ... How could I tweak the Data Validation below which in cell J10 where it ... resides, also include an ability to enter the letters CC? ...
    (microsoft.public.excel.worksheet.functions)