Flagging the duplicated entries

[Sifiso]

Hi Alteryx family.

I am trying to create a flag based on two data fields:

If the [ID’s] are the same AND the [years] are the same, THEN “True” Else “False”

I tried sorting and using the multirow formula, but it does not work for all the rows though they meet the requirements. Please help

#	ID	year
1	100	2003
2	102	2000
3	100	2003
4	102	2000
5	102	2008
6	102	2003
7	100	2003

Desired outcome

#	ID	year	Flag
1	100	2003	True
2	100	2003	True
3	100	2003	True
4	102	2000	True
5	102	2000	True
6	102	2003	False
7	100	2003	False

[alexnajm]

For your Multi-Row Formula, is the size of your newly created field set to 4? It needs to be set to something bigger to accommodate "False" (i.e. 5 or greater)!

[Sifiso]

Hi Alex

thanks, I have increased it. but my problem is the fact that the cells that I have in red boxes are supposed to be True. 

[binuacs · Accepted solution]

@Sifiso One way of doing this