Forum Discussion

DifferentMink01's avatar
DifferentMink01
Copper Contributor
Dec 05, 2022
Solved

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...
excel
Formulas and Functions
DifferentMink01's avatar
DifferentMink01
Copper Contributor
Dec 07, 2022
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
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Dec 07, 2022
    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.
    • DifferentMink01's avatar
      DifferentMink01
      Copper Contributor
      Jan 04, 2023

      Patrick2788 can you help me make it please? I've tried and tried and i cannot doing it alone :'(

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Jan 04, 2023

        DifferentMink01 

        I may have to see the workbook but using this sample for discussion:

        There are 3 things critical to getting this to work.

        1. Select the entire range that will be affected by the conditional formatting. Do not include the header.

        2.  The correct referencing styles for the COUNTIF as seen above.

        3. Starting the formula at the correct row number.  Typically, if the header begins in row 2, the formula must start at row 2.  Note how the formula only references row 2.  If your selection is correct and the referencing styles are tight, Excel will apply the rule correctly to the entire selection.