pull matching data out of spreadsheet and calculate % chances

[amberfig]

I’m trying to figure out the solution to something simple.

I am trying to pull data from tables ripped from the Pokémon games - these tables contain the encounter data for each area, in specific % weighted slots (ranging from 40% to 1%).

There are 12 slots, and what I want to do is the following:

1. Pull each unique occurrence out of each row, which seems fairly straightforward
2. Display the total weighted % chance based on each occurrence.

There’s a lot of this data I need to go through (routing a speedrun though this isn’t really relevant) and I can’t quite figure a way to automate this.

[ve3oat]

Please edit your question above to give us more details, maybe with an example attached. For example, since your goal is to automate the process, you could tell us how you would manually calculate step 2. (At least some of us have never played Pokémon.)