If statement help

[Codedtech]

I have a 57K row dataset that resembles this

User	Domain	AssetType
User1	Domain1	laptop
User1	Domain1	laptop
User2	Domain2	desktop
User3	Domain1	virtual
User4	Domain3	laptop
User1	Domain2	desktop

I'm tying to find a way to create a column that will tell me if a user has an asset on the same domain and if those assets are the same.  
Like this if User1 and  Domain1 and Asset Type are the same the new field would be True. 

[Bren_Spill]

@Codedtech - how about something like the attached?

[Codedtech]

That's a cool solution, but it's not what I need.  This gives me an entry for each line, like User1 has 1Asset on domain1.  I actually need the output to be True or False if user domain and asset type are the same.

[Bren_Spill]

@Codedtech - see attached

[ChrisTX]

Use a Summarize tool.  Group by User and Domain and AssetType, count AssetType.  The use a Filter: Count_AssetType >= 2

Chris

[cjaneczko · Accepted solution]

Here is one way to do it. Create an index field of 1 then use a summarize tool to sum all the "Grouped" fields. Use another formula tool where any of the Sums are greater than 1 is 'True' and anything = 1 is False. Join it back to the original data set.