i want to show only AR-1 's in Serial_Number column in work book filter it by condition and sum of all duration when select a serial_number as filter.

@Suresh Pusuluri​ 

For other patterns, you can just group them:

Then you input the keyword and press "Find All" button:

Then press "Group" button:

Similarly, you can group the rest in the same way