Finding a particular data, that occurs multiple times

[AHACORN]

I have an extensive client list - each client list is also defined to a particular group.

In another sheet, I have made a drop-list using Data Validation with all the groups names, once a group name is selected I want a list of all the Clients within that group.

I have done vlook up but it only gives me the name of the first Client, some groups could have 1 - 17 Clients. So i would ultimately like the sheet to list all of them.

If it helps I have done a Countif function so if Jacksons is selected it would tell me there is 6 Clients in that group.

Sounds so easy to explain but I dont know what formula to use.

I have attached an example of the sheet with the current formulas.

SAMPLE BUDGET.xlsx

I would appreciate any kind of help. THANK YOU

[shg]

Welcome to the board, ahacorn.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[FDibbins]

Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[AHACORN]

Thank you,

I have amended my title but not 100% what to call is as I dont know what formula I require.

Thank you Ford, I have uploaded a sample spreadsheet with the current formulas

[bebo021999]

Try follow these steps:
1) Type 1 in A9
2) From A10 then drag down:
=IF(MAX($A$9:A9)<$I$4,A9+1,"")
3) C9:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
4) Drag C9 down
Hope it helps.