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.
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
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
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
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