BEGIN{OFS=FS=","} $2>a[$1]["max"]{a[$1]["max"]=$2} $2<a[$1]["min"] || !a[$1]["min"] {a[$1]["min"]=$2} END { for (i in a){ print i, a[i]["min"],a[i]["max"] } }
Task2, 3421 Task3, 3300 Task1, 1000 Task2, 1100 Task3, 1200 Task3, 1209 Task4, 1299 Task3, 1289 Task1, 1389 Task2, 1211 Task5, 1216 Task2, 1416 Task1, 2100 Task6, 2416 Task5, 2216 Task7, 1116
Task1, 1000, 2100 Task2, 1100, 3421 Task3, 1200, 3300 Task4, 1299, 1299 Task5, 1216, 2216 Task6, 2416, 2416 Task7, 1116, 1116