Function that lists specific rows of a database based on a cell value

Hello everyone!

The newest task I'm facing at work is the following:

I will have a database with around 2000 entries. all of them will have a name and an assigned value (among other things). the value assigned to names could be from 1 to 25 (so there is 25 possibilities in terms of values).

What I'm looking for is a function that can list all entries that belong to a specific value. For example a function that lists all names with the value 5. I beleive I will have to write 25 separate functions, since I will be needing the lists for all values simultaneously.

I'm hoping that there is a function for this and it's just my lack of knowledge that makes this task complicated and time consuming for me (I came up with a solution for 15 entries, but it took me a lot of steps and time to make it happen).

Also, all this has to happen automatically, so I'm looking for other solutions than manually filtering (because this problem is just part of a chain of functions).

If anyone has any ideas, I'd be extremely glad to hear them.

Thank you in advance!

All the best,

Peter

Post an example workbook so we can see exactly what you want to do.

Pete

Hey Pete,

Thanks for the reply!

Attached is an example of what I was thinking of!

Best,

Peter

Attached file shows how to do it, using two formulae.

Hope this helps.

Pete

Thank you so much! This looks great! I'll only be able to try it on the original tomorrow, since it's at work. I'll let you know how it went. Thank you once again!

Peter

It works great! Thank you. With all these calculations, it slows down the computer a bit (an old computer), but that's obviously not the functions fault. It does exactly what I need. Thanks Pete, you cannot imagine how much this helped me!

Have a good day!

Peter

@ setilvenstre

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Hi Cutter!

Sorry, I thought I already marked is as solved. Thanks for the heads up!