Unique data in column or row in Excel
Hi Ali,
Try to use this formula in Data/Validation/Custom:
=ISERROR(MATCH(A1,INDIRECT("A1:A"&CELL("row",A1)-1),0))
Regards,
Stefi
€žAli€ť ezt Ă*rta:
I have a problem with posibility of repeating data in column. Of course this
is normal behaviour of Excel, but I need to assure unique data in column. Is
there a way to do this without an extra effort?
|