Find all values and list

**Zsoup** · 03-22-2013, 09:13 AM

I'm working on a spreadsheet and I'm trying to get a list of all account over a certain amount of users. I'm trying to do this without a pivot table too. In other words I want to have a box that says "Select amount of users". Someone can key in >15 and list of the account names appear in a predetermined part of the sheet. Is this even possible???

Thanks!

**Pete_UK** · 03-22-2013, 09:38 AM

Yes, it is possible.

Post a sample workbook, and I'm sure you will get lots of suggestions.

Pete

**Zsoup** · 03-22-2013, 09:43 AM

SampleEX.xlsxThanks, I attached a sample of what I'm looking for. Also, did I state that I'm looking for this to be all formula based?

**Pete_UK** · 03-22-2013, 10:13 AM

I had composed a long reply explaining the formula, then when I clicked on Go Advanced to attach the file I got a "Database Error" and lost all the text. I can't seem to add the file as I get the "Too busy" message, so I'll try later - if you have any questions then post back. Just change the number in B3 to see the table change (when you get the file).

Hope this helps.

Pete