Identify biggest value in rows

[Joker_Hazard]

Greetings.

I have a dataset that contains 300k lines and a column that calculates the amount of days compared to weekend dates.

Basically it creates a result that if its monday or tuesday, then it gives a range of results in 0,1,4.

If its wednesday, tuesday or friday, it gives a range of results in 0,1, 2.

Therefore, I always filter the biggest number, to continue with the workflow. I have been changing the filter manually knowing that if today's date is monday, then number 4 has to be filtered. I want to automate that by creating a formula that will ALWAYS filter the biggest value in this column. I tried using multirow, but as there are 3 different numbers I couldn't figure out how to create.

Anyone has any clever idea on how to create a formula like that? Is there any tool that can filter the max values of rows while maintaining dataset structure? (I thought of summarize, but I have to keep all columns).

Example:

Thanks

[DataNath · Accepted solution]

How does this look @Joker_Hazard? It takes a max, appends it to all records and then filters out those that aren't = to the max before removing it and just leaving your original data structure:

[gabrielvilella · Accepted solution]

Hi @Joker_Hazard, is this what you are looking for? It's quite hard to understand what you want without the actual dataset and the expected outcome.