September 12th, 2011, 03:11 PM
Need help creating a function
I have an excel file that has a series of values stored as their names (dog, cat, snake) as AnimalType.
What I need to do is for each value of AnimalType I want to programmatically determine what type it is:
IF AnimalType column = Snake
Then Snake column =1)
THe point is to parse the entire excel and for each predetermined value of AnimalType put a 1 or 0 next to its corresponding AnimalType name.
The end result is I want to be able to query for all of the snakes or cats or both...