I'm trying to come up with a formula that will look at a hire date and end of year date. If the total months exceeds 9 months, then the statement is true. Less than 9 months the statement is false. For example, an employee is hired 08/15/2013 and the end of year date is 12/31/2013. Since the total time of employment is less than 9 months the statement would be false.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.