I am working on a spreadsheet that will keep track of our employees Sick, vacation, and holiday times. Per the boss, it has to be in a certain format. I have prepared the spreadsheet - no problem. However, he wants to enter the sick time as 4S, and then run a search on just the cells that have S and have it automatically calculate on the spreadsheet.

How in the world would I go about doing that?