Data validation problem

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

From: Yan Robidoux (Yan.Robidoux.1a7is7_at_excelforum-nospam.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 07:37:21 -0500

Hail to you all....

First post here and hopefully the last...
Second, sorry if i'm not on the right board...
Third, sorry for my not perfect english....

Well enough "being sorry thing" here my problem...

I'm currently validating a form in excell and some bug just got into
the equation wich i cannot remove (solve)....

I got a list of text value c4:c28 wich contain some number like "p-12"
i got a cell g4 wich CANNOT take any of the value in c4:c28
here what i got thus far :
=MAJUSCULE(G4)<>RECHERCHE(MAJUSCULE(G4);C4:C28;C4:C28)

it in french so i will give you some highlight on the formula :
majuscule convert the string in capital letter ...
recherche search through the array... (search formula in english ?)

up to now it work except :
- somme letter alway's generate error : a-e-d-f-o for example. Other
are just fine w-s-r-x-t.
- number generate error

why does these specific entry generate error's ? i would understand if
ANY entry were wrong but why some specific ?

thanks in anvance for any help....

PS: the must be a better way to do this but i cannot find the formula i
need in the french version of excell... im at my job and cannot install
the english version... sorry about the inconvenience... 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages