Forum Discussion
avoid to repeated data values in excel formula
The screenshot is a bit blurry, but I believe I understand your request. Please see attached workbook.
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.
- I think that is what I'm looking for! ( i did not understand the attached workbook, but I searched in excel for the phrase "conditional formatting" and I got this result: "=if(logical_test,value_if_true,value_if_false") do you know how to do it, please? :3
- The conditional formatting is using a formula to determine if the ID counted in a given cell is the first instance encountered. If it's not instance 1, the conditional formatting applies custom format ;;; which is a way of saying don't show cell contents.
Patrick2788 can you help me make it please? I've tried and tried and i cannot doing it alone :'(