I have a ranking sheet and have determined who moved forwards based on this
weeks/last weeks position using large,cellrange,1 but when using lookup to
put a name to number it returns a person with 0 value, by omitting this
person i can get the result that i want, but how do i get lookup to ignore 0
values?