Forum Discussion

Dromerolovo95's avatar
Dromerolovo95
Copper Contributor
Jun 09, 2020
Solved

Data Validation custom formula

I'm trying to apply this formula to data validation but it's not working. The formula works fine in a normal cell though    =LARGE((C10=OFFSET(C10,(ROW(C10)-ROW($C$3))*-1+1,0,ROW(C10)-ROW($C$3)-1))...
excel
Formulas and Functions
office 365
  • mtarler's avatar
    mtarler
    Jun 10, 2020

    Dromerolovo95It looks like you have 1.0 instead of 1,0 which changes your offset from shifting 0 columns and increasing your row range to shifting your columns off the page.

    also a simpler formula could be:

    =COUNTIFS(C:C,C10,D:D,D10)=1

     

mtarler's avatar
mtarler
Silver Contributor
Jun 10, 2020

Dromerolovo95It looks like you have 1.0 instead of 1,0 which changes your offset from shifting 0 columns and increasing your row range to shifting your columns off the page.

also a simpler formula could be:

=COUNTIFS(C:C,C10,D:D,D10)=1

 

Resources