I have a spreadsheet which contains months of data for golfers. Some play
every saturday, some play when they are here on holiday. For months I have
input data and left blanks when the players were not here. This worked until
yesterday when someone asked, can we see each players last 6 weeks results
when they were playing. The formula I use for last result is
=IF(INDEX(C:C;MATCH(99999999999;C:C));(INDEX(C:C;M ATCH(99999999999;C:C))))
and for the next I
use=IF(INDEX(C:C;MATCH(99999999999;C:C)-1);(INDEX(C:C;MATCH(99999999999;C:C)-1))).
The First bit was ok but the next bit showed a blank if it was their week
off. I want the blanks ignoring, and numbers only displayed. Any ideas?