Hi DOMO -
Is there a way to do this excel formula in Beastmode?
=COUNTIFS($A$2:$A$8, $A2, $B$2:$B$8, $B2)
basically, it shows the duplicates based out of 2 columns.
what we have is the Name and the Title and the location
we want to see how many names have the same title
for example:
Peter Manager San Francisco
Peter Manager California
Paul Director Florida
Paul Manager Orlando
In the example above, Peter has the same title, so we want to mark Peter as True since he is a manager more than once.