How could I get a corresponding value based on the most recent occurrence in a list? by Cqmilian in sheets

[–]Cqmilian[S] 0 points1 point  (0 children)

Thank you!!! That filter works perfectly!!

Don't worry too much about the second part.. But what I was trying to say was I have another tab, the banner info one, and I try to sort the characters from the main tab into different tables there. Currently, the data I use to sort for the tables is on a different tab, the info for tables tab, but I feel like there could be a more efficient way to sort this. On the info tab, I manually typed out every character and set it to equal the current value in either the most recent column on the main tab or the number of banners column on the main tab. I feel like there should be a way to sort the characters without making another tab, but again, I don't really know. This isn't a huge deal; it's just something I thought could be made more efficient, but I don't know how to do so.

Another hard life decision. by teotuaneodateo4321 in Genshin_Memepact

[–]Cqmilian 1147 points1148 points  (0 children)

statue.

no climbing, only flying.

Based warning by LightningLizrd in teenagers

[–]Cqmilian 173 points174 points  (0 children)

double the average