Hi
I am having an excel sheet like below. I need to group them in Field name route and assign a value for route field .
let's say (routeNo) or any other unique value.
the grouping is based on finding a value that is considerable above of other previous records
below is 48. which is very big than other previous ones.
Any help is highly considered.
Route 1
Route 2
