Validating a Data Entry ...

Rams · Apr 9th, 2002, 06:40 AM

Hi,

Say, Cell A3, has Code with a drop down list box. I'm picking the 1st item "cd01". The Code Name is displayed in B3. C3 has division, which is again a drop down list box. I'm picking "APD".

Next entry by mistake if I happen to select cd01 and APD again, I must display an error message.

Hope you must have understood my problem.

I'm getting problem with your edit option. It's not allowing me to edit, so I'm re-entering this question again.

Regards.

Rams

Juan Pablo González · Apr 9th, 2002, 06:44 AM

I think, not sure, that you could use Data Validation for this, with a formula, something like

=COUNTIF(A$1:A1,A1)=1

For the "Edit" part... I believe it only allows you to edit it for the next 30 minutes after you have posted.

sen_edp · Apr 9th, 2002, 06:56 AM

Hello Rams
go to the following link

http://support.microsoft.com/support.../Q213/1/85.ASP

Andreas

Rams · Apr 9th, 2002, 06:57 AM

Hi,

I don't need the count of it. I want to avoid the redundancy of records being entered. It's just a way of entering unique records.

How will I display the error message for this ?

Regards.

Rams.

Rams · Apr 9th, 2002, 07:22 AM

Dear Sen_edp,

Thank you very much for the link that you provided to me. I'm currently working on it. If I'm successful in it, I'll inform you.

Regards.

Rams.

Apr 9th, 2002, 06:44 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	I think, not sure, that you could use Data Validation for this, with a formula, something like =COUNTIF(A$1:A1,A1)=1 For the "Edit" part... I believe it only allows you to edit it for the next 30 minutes after you have posted. __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Apr 9th, 2002, 06:40 AM	#1
Rams New Member Join Date: Apr 2002 Posts: 4	Hi, Say, Cell A3, has Code with a drop down list box. I'm picking the 1st item "cd01". The Code Name is displayed in B3. C3 has division, which is again a drop down list box. I'm picking "APD". Next entry by mistake if I happen to select cd01 and APD again, I must display an error message. Hope you must have understood my problem. I'm getting problem with your edit option. It's not allowing me to edit, so I'm re-entering this question again. Regards. Rams

Apr 9th, 2002, 06:56 AM	#3
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	Hello Rams go to the following link http://support.microsoft.com/support.../Q213/1/85.ASP Andreas

Apr 9th, 2002, 06:57 AM	#4
Rams New Member Join Date: Apr 2002 Posts: 4	Hi, I don't need the count of it. I want to avoid the redundancy of records being entered. It's just a way of entering unique records. How will I display the error message for this ? Regards. Rams.

Apr 9th, 2002, 07:22 AM	#5
Rams New Member Join Date: Apr 2002 Posts: 4	Dear Sen_edp, Thank you very much for the link that you provided to me. I'm currently working on it. If I'm successful in it, I'll inform you. Regards. Rams.