Need help with Excel command

cenahum · May 12th, 2002, 08:38 PM

Hi guys, I just wanna know if has some way to prevent repetitions in excel, there is some command ? like when you are writting a sequence of numbers and you don't want to write 2 or 3 equals, when I used dbase was a coomand if I still remember was : set unique on. has this kindda funtion on excel ?
thanks in advance
cenahum

Aladin Akyurek · May 12th, 2002, 09:03 PM

Quote:

On 2002-05-12 19:38, cenahum wrote:
Hi guys, I just wanna know if has some way to prevent repetitions in excel, there is some command ? like when you are writting a sequence of numbers and you don't want to write 2 or 3 equals, when I used dbase was a coomand if I still remember was : set unique on. has this kindda funtion on excel ?
thanks in advance
cenahum

Consider using data validation, see the Help file.

Nimrod · May 12th, 2002, 09:03 PM

I'd love to help but I'm not exactly sure what your asking for... could you please give an example.

cenahum · May 12th, 2002, 09:40 PM

first thanks all you for anwser me
sample of the problem
you have a list with a lot of numbers and you are gonna import it to a plan, later you recive another list with numbers and you are gonna put together with the other numbers at the same plan, but you do not want repetition.
Is that clear ( sorry but my english isn't so good)
cenahum

cenahum · May 13th, 2002, 04:54 AM

Still haven't a way to do the check.

May 12th, 2002, 09:03 PM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	I'd love to help but I'm not exactly sure what your asking for... could you please give an example. __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 12th, 2002, 08:38 PM	#1
cenahum New Member Join Date: May 2002 Posts: 3	Hi guys, I just wanna know if has some way to prevent repetitions in excel, there is some command ? like when you are writting a sequence of numbers and you don't want to write 2 or 3 equals, when I used dbase was a coomand if I still remember was : set unique on. has this kindda funtion on excel ? thanks in advance cenahum

May 12th, 2002, 09:40 PM	#4
cenahum New Member Join Date: May 2002 Posts: 3	first thanks all you for anwser me sample of the problem you have a list with a lot of numbers and you are gonna import it to a plan, later you recive another list with numbers and you are gonna put together with the other numbers at the same plan, but you do not want repetition. Is that clear ( sorry but my english isn't so good) cenahum

May 13th, 2002, 04:54 AM	#5
cenahum New Member Join Date: May 2002 Posts: 3	Still haven't a way to do the check.