Flagging only one of the duplicate rows which are belong each user

[acaryasin01]

Hi guys,

I have a table that is filtered duplicated users like below. 

I want to create a new column that is flagged as "Revoke" based on each duplicated User according to its "Last Login" column which is oldest one.

That means flag the each duplicated user's row which is older "Last Login" date than the other in the same user as "Revoke" who has more than one "Last Login" entry.

Any ideas !

My Dataset

User	Version	Device ID	Last Login
A	2020.4	345	25-6-2020 13:10
A	2019.3	346	11-11-2020 07:55
B	2019.3	244	24-9-2020 13:14
B	2020.2	243	23-12-2020 07:45
C	2019.3	456	27-11-2019 12:14
C	2020.3	457	4-12-2020 15:08
D	2019.3	567	9-10-2020 09:28
D	2020.2	569	30-12-2020 08:09

Desired Dataset

User	Version	Device ID	Last Login	Revoke
A	2020.4	345	25-6-2020 13:10
A	2019.3	346	11-11-2020 07:55	Revoke
B	2019.3	244	24-9-2020 13:14	Revoke
B	2020.2	243	23-12-2020 07:45
C	2019.3	456	27-11-2019 12:14	Revoke
C	2020.3	457	4-12-2020 15:08
D	2019.3	567	9-10-2020 09:28	Revoke
D	2020.2	569	30-12-2020 08:09

[atcodedog05 · Accepted solution]

Hi @acaryasin01 

Here is how you can do it.

Workflow:

1. Sort by user and sort descending on last login.

2. Using mult-row formula tool to flag revoke. If the row is not first row for user flag revoke. This is doesn't flag the latest last login row for user.

Hope this helps : )

[acaryasin01]

Perfect It works, Thank you so much 😊 @atcodedog05  

Also Thanks for fast reaction 👍

[atcodedog05]

Happy to help : ) @acaryasin01