select node where integer field is closest to another field

I have a view which is returning a bunch of rows where each row contains two integer values. One value is consistent across all rows and the other varies, for example...

answer:5, guess:2
answer:5, guess:4
answer:5, guess:8

In this example I need to somehow return the row with the closest value for guess, to the value for answer. So here it would be the second row. If there are multiple rows which are the closest (eg 2 rows with guess:4) it would return both of them.

Is this possible with views?!