Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to compare text across multiple columns

Hi,   How do i compare text across multiple columns ignoring any blanks and ignoring case. e.g.   Column1 Column2 Column3 Column4 Column5 Expected Result cat cat cat cat cat TRUE...
  • lbendlin's avatar
    lbendlin
    5 years ago
    Result =
    var a= {[Column1],[Column2],[Column3],[Column4],[Column5]}
    var b=FILTER(a,[Value]<>"")
    return COUNTROWS(DISTINCT(b))=1
     
    or more brutish:
    Result = COUNTROWS(FILTER(DISTINCT({[Column1],[Column2],[Column3],[Column4],[Column5]}),[Value]<>""))=1
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago
Result =
var a= {[Column1],[Column2],[Column3],[Column4],[Column5]}
var b=FILTER(a,[Value]<>"")
return COUNTROWS(DISTINCT(b))=1
 
or more brutish:
Result = COUNTROWS(FILTER(DISTINCT({[Column1],[Column2],[Column3],[Column4],[Column5]}),[Value]<>""))=1
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Both Solutions work.  Thank You so much.