How to filter multiple entries in a col of a excel sheet dynamically

[Asad1]

I have a excel sheet where I have multiple entries in col1 and 2, where col 1 has the name of the people and col 2 has their respective time spent in a day, for example:

Col 1     Col 2

B1         2hr

B1         2hr

B1         2hr

C1         3hr

C1         4hr

C1         4hr

So, what I want to do is that for B1 and C1 I want to check their respective total time so in B1 the total time is 6hr where as for C1 it is 11hr. My threshold for the time is 9hr, so if the time is above 9hr I do not want to consider that person, so in this case C1 would be discarded and in the next step I only want to consider B1.

Please be mindful that there can be multiple different entries for example B1, C1, D1, E1 … so on and I need to check for each and filter accordingly. Also remember that I do not think that using a filter tool would be a good idea as there might be a lot of entries so is there a dynamic way, I could do the filtering for all the entries altogether?

[mzak89]

Hello!

Please try something like this :)

Kind regards
Mateusz

[terry10]

To sum up the hours for each person, you first need to convert to values in Col2 from text to numbers. Then you can simply use the Summarize tool and filter for those with Total hours <= 9.

Workflow attached.