For example:
FTjklkjs
fdZS fjkjjd
sdajkl JSsdf
afdjk Fj
Ajkj Ajkljk
Also, a variation, whether a cell contains all caps, i.e.
RTY
GSKLK
JSI JFKD
ZFIOS
AEs jfkjkj
gfklk Sklkf
Egdkl Sstskl
For example:
FTjklkjs
fdZS fjkjjd
sdajkl JSsdf
afdjk Fj
Ajkj Ajkljk
Also, a variation, whether a cell contains all caps, i.e.
RTY
GSKLK
JSI JFKD
ZFIOS
AEs jfkjkj
gfklk Sklkf
Egdkl Sstskl
Question 1.
Assumes: column A is empty, data are in column B, C1 contains the digit 1
D1contains this equation (copied down)
Formula:Please Login or Register to view this content.
and D1 contains
.Formula:Please Login or Register to view this content.
Question 2.
In H1, copied down
Formula:Please Login or Register to view this content.
In I1:
.Formula:Please Login or Register to view this content.
sEE THE ATTACHMENT, TOO.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
A one-line UDF would make it pretty simple:
A B C 1FTjklkjs TRUEB1: =LikeThis(A1, "*[A-Z][A-Z]*") 2fdZS fjkjjd TRUE 3sdajkl JSsdf TRUE 4afdjk Fj FALSE 5Ajkj Ajkljk FALSE 6 7RTY TRUEB7: =NOT(LikeThis(A7, "*[a-z]*")) 8GSKLK TRUE 9JSI JFKD TRUE 10ZFIOS TRUE 11AEs jfkjkj FALSE 12gfklk Sklkf FALSE 13Egdkl Sstskl FALSE
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
My solution is many things... but it's neither pretty, nor simple
Messy to do via formula.
shg, for some reason, both functions give me #NAME?
Did you look at the (messy) formula that I used, which does appear to work OK?
Sorry my bad! Did not properly read the OP's request
Alf
Last edited by Alf; 06-15-2014 at 06:41 AM. Reason: Did not read OP's request
Did you open the VBA editor (Alt F11) and insert a module then copy and paste the function code as written into the module?
The next thing for it to work was to enter the formula EXACTLY as SHG wrote it
Formula:Please Login or Register to view this content.
I tried it and it works just fine.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
That will depend on the delimiter used in Greece i.e. probably ";" instead of ","it to work was to enter the formula EXACTLY as SHG wrote it
Oh no I guess there are quite a number of us who do soI thought I was the only one who did this sort of thing ...
Alf
best i can come up with apart from a udf is this array entered formula
Formula:Please Login or Register to view this content.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks