Well thanks for the input but, this isn't really what im looking for. It's probably my fault for not having worded properly. What he needs is an Excel formula, like IF,OR statements etc. he doesn't need it to all to be one formula though, by that i mean if you think you can make it by putting one formula in one cell then another forumla in another etc. then that's fine.