Hey guys! I finally succeeded in adding this long awaited feature called “Filtering” for the Tier List ;D

Basically, what this feature does is that it display values as you wish to. Let’s say, you only want to display the “Awakened Heroes” on the list for easier viewing, this feature does the trick by filter out the non-relevant results.

And here is how to do it:

First thing first, open the tier list (lol!). You’ll see an extra row above every other rows with 3 different fields (Filter by Affiliation, Filter by Class and Filter By Role) in all 3 sheets.

1.png

Secondly, left click and drag to bolden those 3 fields (remember, just those 3 fields – E3,F3,G3)

2.png

Then, click the Filter icon on the top right corner, which looks like this:

3.png

Click ‘create temporary filter view’ and the list will look like this:

4.png

The bolden fields now have three arrow-down button on each of them:

5.png

And you’re done the prepping step! Now let’s try filtering out. For example, I want the list to display all available Quinque Dracos, I’ll first click the button of the “Filter by Aff.” field. It should look like this:

6.png

The drop down menu should have all 5 affiliations displayed with check-mark. To display only the Dracos, I will uncheck all other fields and it should look like this:

7.png

Now that the Quinque Draco is the only Affiliation checked, I will go on and click OK. The list will then be narrowed down to look like this:

8.png

You can also try different combination to display your most desired values too😀 Like, “display all Priest Awakened Heroes” or “display all Archer Bodens”, etc.

Finally, to return the list to its normal state, re-select the Filter icon and click “None”:

9.png

And you’re good to go ;D

Well that’s it for this guide, I hope you guys enjoy browsing the tier list and remember, don’t hesitate to drop me a comment regarding issues with the function😉

Catch ya later!

-Amarantine.

2 thoughts on “[3.5.1] Filtering and how to filter

  1. hi, wanna ask.

    there will be a specific time/day where I can’t hover on any cells of your tier list, to show description. Its like the spreadsheet in “Lite” mode.

    any idea what went wrong?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s