Please see the video below:
I am doing exactly what is being done in the video. The problem I have though is, this will only work on a specific computer because of the directory. What I need to do is transfer both the excel files to many computers. So when I do that and open the file that has...
I have the following excel content:
Fruit In/Out
Apple 1
Orange 1
Watermelon 1
Banana 1
Apple 0
Orange 0
Peach 1
Apple 1
I want the final result to look like:
Fruit In/Out
Watermelon 1
Banana 1
Peach 1
Apple 1
What I want is to delete every fruit that has been "In" as well as been "Out". For...