Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

2010-10-16 Thread C.G.Kumar
Use the following formulae ; IF(COUNTIF(A$1:A1,A1)=1,Unique,Dupl) Hope it serve the purpose. Thanks Regards, C.G.Kumar On Wed, Oct 13, 2010 at 8:43 PM, vinod rao vinod.ma...@gmail.com wrote: HI I have multipal duplicate numbers and excluding one for others it should say duplicate.

Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

2010-10-15 Thread P.VIJAYKUMAR
Dear Ansari, You can use Data Validation for the duplicates, Regards, Vijay On Wed, Oct 13, 2010 at 8:43 PM, vinod rao vinod.ma...@gmail.com wrote: HI I have multipal duplicate numbers and excluding one for others it should say duplicate. how do i enter formula in 2003/2007 Thanks

Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

2010-10-14 Thread NOORAIN ANSARI
Dear Srinivasan, Below formula is not working properly. We are unable to find valid output. Please suggest... Thanks, Noorain Ansari On Wed, Oct 13, 2010 at 10:33 AM, Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com wrote: Paste the below formula in D2 =IF(COUNTIF(A$2:A2,A2)=1,Unique

Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

2010-10-14 Thread Srinivasan Ethirajalu
Pls find the attachment On Thu, Oct 14, 2010 at 1:10 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Srinivasan, Below formula is not working properly. We are unable to find valid output. Please suggest... Thanks, Noorain Ansari On Wed, Oct 13, 2010 at 10:33 AM, Srinivasan

Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

2010-10-13 Thread Srinivasan Ethirajalu
Paste the below formula in D2 =IF(COUNTIF(A$2:A2,A2)=1,Unique / First occurrence,Duplicate) and copy paste the formula to the down cells in D column On Wed, Oct 13, 2010 at 8:43 PM, vinod rao vinod.ma...@gmail.com wrote: HI I have multipal duplicate numbers and excluding one for others it