Find How many Employees are using the same account number

[hemant86]

HI All,

I need to pull a report of how many employees are using a single account at present date. Please find the sample table below. If I had to do it on excel the I would put a filter on column Account Number and if the count of rows is >=2 then I would pull that data. Any help will be greatly appreciated.

Empl ID	Autolink	Pay Group	Account Number	Effective Date
100	447605	Y1K	1111	10/30/2019
200	61386	WLQ	1111	07/17/2019
300	465835	Y1K	2222	11/07/2019
400	325790	Y1K	2222	08/30/2019
500	325790	Y1K	2222	09/21/2019
600	325790	Y1K	3333	09/24/2019
700	325790	Y1K	3333	10/11/2019

expected output

Empl ID	Autolink	Pay Group	Account Number	Effective Date
100	447605	Y1K	1111	10/30/2019
200	61386	WLQ	1111	07/17/2019
300	465835	Y1K	2222	11/07/2019
400	325790	Y1K	2222	08/30/2019
500	325790	Y1K	2222	09/21/2019

[hemant86]

Thanks Qiu...sorry I missed out on mentioning earlier. Actually a beginner in Alteryx. Can we get the 3rd row excluded since its allocated to only one Empl ID and are duplicates. The records will contain such duplicates. Thanks Again for your help!