Re: $$Excel-Macros$$ Unique No

Vivek, The steps given earlier are not exactly good. Try it this way - 1. Select the cell A1 2. Data --> Data Validation --> Settings 3. From the Allow dropdown list, select Custom. 4. Enter the following COUNTIF formula in the Formula box: =COUNTIF(A:A,A1)=1 5. Select the Error Alert tab. 6. In

Re: $$Excel-Macros$$ Unique No

Vivek, Have you tried Data Validation ? See this: 1. Select the range to validate (cells A2:A10) 2. Data --> Data Validation --> Settings 3. From the Allow dropdown list, select Custom. 4. Enter the following COUNTIF formula in the Formula box: =COUNTIF(A:A,A1)=1 5. Select the Error Alert tab. 6

RE: $$Excel-Macros$$ Unique No

Subject: $$Excel-Macros$$ Unique No Hello All... A Column in a sheet must have only unique nos... when we enter the same no again it have to give t message NO ALREADY EXIST. pls help to to find it out. Thanking you, Vivek Chandran, Ooty - TN

$$Excel-Macros$$ Unique No

Hello All... A Column in a sheet must have only unique nos... when we enter the same no again it have to give t message NO ALREADY EXIST. pls help to to find it out. Thanking you, Vivek Chandran, Ooty - TN -- --