Hello,
I am currently making a project for my online hockey league team, and I am using a spreadsheet to do this. I been able to work out most stuff, but I now want to implement a feature that I have no knowledge on.
Basically, what I want is 5 cells telling me my next 5 games. I have got that working and telling me how many days until my next game, but is there anyway to tell excel to delete the data that is in the past. For example, a day after my game it will say -1. But I want it to be deleted, and move the rest of the cells below it up.
If someone could help I'd be very grateful.
Thanks
Will
Bookmarks