Forum Discussion
avoid to repeated data values in excel formula
I understand there's a formula you can write down manually in a single cell of a column and then drag down, to avoid repeated data values in excel with the "=COUNT.SI(XXXXXX)=1" but i forgot how to do it correctly. I know there's a function in Data menu > Data validation, but the rank i will use is the WHOLE COLUMN, not just a short rank. That is why I want to manually write the formula down in the second cell (my chart has headers) and then drag the formula down, as my chart fills up. Can anyone can help me, please?
The screenshot is a bit blurry, but I believe I understand your request. Please see attached workbook.
7 Replies
Are you referring to using this formula:
=IF(COUNTIF($A$1:A1,A1)=1,COUNTIF($A$1:A1,A1),"")To do this?
Hello Patrick2788! No, that formula is to count items. I'm looking for the avoid repeating data formula when you are filling up a database. Something like this, see column B, please...
the name of the client will repeat, but the code of the item in column B must not 😞 That is the formula I'm looking for =count.if(x:x;x,x)=1, but I don't remember how to write it down inside column B manually and then drag the formula down alongside the whole B column, without the data validation option in the data menu
The screenshot is a bit blurry, but I believe I understand your request. Please see attached workbook.
