BEGIN { for (foo=0; foo<2000; foo++) values[foo] = 120; } { values[$1] = $2; if ($2 < minimum[$1]) minimum[$1] = $2; if ($2 > maximum[$1]) maximum[$1] = $2; } END { for (foo=0; foo<2000; foo++) { print foo, values[foo]; } }