I need sum of the cycles as well In the attached workbook and even if the cycle indicates '3' in count it should be consider as 1 and I need only AR1 and AR-1 to show in the filter SERIAL_NUMBER. Please help

See attached.

If it Helps, Please Upvote and Select as Best to close Thread.