Durbs
Durbs

Classically British
Location: Epsom, Surrey, England
Member Since: 23rd Sep 2001
Total posts: 5688
Posted:smile

I'd consider myself a fairly advanced user of Excel, but i'm currently struggling...

Is there a way to make excel not let you enter the same thing twice?
i.e. I'm creating a table, but if i enter the same value more than once, can i make it go "bing" and not let me enter it?

I've trawled through validation, but can't see anything there, and aside from boshing up a quick formula to check if anything is entered more than once and making it flash red, then i can't think how to do it...

Thoughts?


Burner of Toast
Spinner of poi
Slacker of enormous magnitude

Delete Topic

Brenn
Brenn

Will carpal your tunnel in a minute.
Location: Melbourne, Australia
Member Since: 28th Jun 2004
Total posts: 3286
Posted:um... off the top of my head you could have:

=IF(current cell=cell:cell, current cell,"Duplicate value found")

possibly?


ॐ

Owner of burningoftheclavey smile
Owned by Lost83spy

Delete

Durbs
Durbs

Classically British
Location: Epsom, Surrey, England
Member Since: 23rd Sep 2001
Total posts: 5688
Posted:Yeah, but that involves typing that into each cell...

I just want to plug values into the cells as normal, but if i type something in twice, it lets me know...


Burner of Toast
Spinner of poi
Slacker of enormous magnitude

Delete

Brenn
Brenn

Will carpal your tunnel in a minute.
Location: Melbourne, Australia
Member Since: 28th Jun 2004
Total posts: 3286
Posted:Hmm... Not sure. Will have to get back to you on that one hug

ॐ

Owner of burningoftheclavey smile
Owned by Lost83spy

Delete

UCOF
UCOF

Carpal \'Tunnel

Member Since: 17th Apr 2002
Total posts: 15414

Durbs
Durbs

Classically British
Location: Epsom, Surrey, England
Member Since: 23rd Sep 2001
Total posts: 5688
Posted:The second one is perfect smile

Burner of Toast
Spinner of poi
Slacker of enormous magnitude

Delete

UCOF
UCOF

Carpal \'Tunnel

Member Since: 17th Apr 2002
Total posts: 15414
Posted:80110ck5.
ubbcrying

Like I said on MSN, I'll keep looking till I find the right one.


Delete

Yakumo
Yakumo

veteran
Location: Oxfordshire
Member Since: 31st May 2006
Total posts: 1237
Posted:specifically are you saying the same number in the same cell by accident, or the same number in the column(range) your working in?

did ucof's previous comment not help in the end? or is his last one just to throw people off...


Blinded by Hyperlights, please donate generously grin

Delete

UCOF
UCOF

Carpal \'Tunnel

Member Since: 17th Apr 2002
Total posts: 15414
Posted:*nods head in agreement*

wink


Delete

Durbs
Durbs

Classically British
Location: Epsom, Surrey, England
Member Since: 23rd Sep 2001
Total posts: 5688
Posted:He's being obtuse...

Burner of Toast
Spinner of poi
Slacker of enormous magnitude

Delete

UCOF
UCOF

Carpal \'Tunnel

Member Since: 17th Apr 2002
Total posts: 15414
Posted:Acute... surely wink

Delete

Yakumo
Yakumo

veteran
Location: Oxfordshire
Member Since: 31st May 2006
Total posts: 1237
Posted:and your both leaving me confused as to if durbs needs help still or not tongue ubbcrying

Blinded by Hyperlights, please donate generously grin

Delete

Durbs
Durbs

Classically British
Location: Epsom, Surrey, England
Member Since: 23rd Sep 2001
Total posts: 5688
Posted:well yes, i need help - but not with Excel wink

Burner of Toast
Spinner of poi
Slacker of enormous magnitude

Delete

MikefromGlos
MikefromGlos

Hitman
Location: Gloucester England
Member Since: 10th Jul 2006
Total posts: 985
Posted:for future reference if u enter a fomula if u click on the cell u entered it into then click and drag on to the little black box in the bottom right hand corner then it duplicates it into all the cells u draged it over

he he i am mike the amazing gloscircus person who is mike.

Officaly an exception to the Poi Boys are Girls Thing

Delete

UCOF
UCOF

Carpal \'Tunnel

Member Since: 17th Apr 2002
Total posts: 15414
Posted:for future reference if you click the "X" in the the top right hand corner of the screen, it closes Excel! wink

Delete


Similar Topics

Using the keywords [excel] we found the following similar topics.
1. Forums > Excel question [14 replies]
2. Forums > Read Numeric value From Excel [4 replies]
3. Forums > Please Help, problem with cellType [5 replies]
4. Learn > Interviews > Pele > Batavia performer chose a really hot career path *help/resource career out of her burning desire to excel at the offbeat  the lifelong...
5. Forums > Poi Wallpaper [25 replies]

     Show more..