Trying to figure out the formula for something, hopefully it exists.
Example:
1. Twenty entries (20 cells), they contain one of three words.
2. I want to be able to type in the correct word into a cell.
3. I need a formula that matches the words and if they're the same, spit out a number into another cell and if they're not then spit out a zero into another cell.
Is this possible?
--
Menji - Sign My Petition for "Search By Username"
http://www.gamefaqs.com/boards/7-site-suggestions/55168396