Count same occurrences in different fields

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • isantiago926
    New Member
    • May 2015
    • 1

    Count same occurrences in different fields

    I'd like to know ho I can compute a count of the same names or codes between different fields.
    For example, I have 4 fields each with different region names.
    I'd like to have a field counting all equal occurrences comparing all fields.
    If f1="X",f2="X",f 3="X",f4="X"
    then CountField = 4
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32661

    #2
    And what if F1='X', F2='Y', F3='Y' & F4='Z'?

    Please express your requirement precisely.

    Comment

    Working...