Page 1 of 1
[Solved] Filtering feature needed
Posted: Wed Mar 04, 2015 2:24 am
by awascholl
I have a spreadsheet with a column of names, and next to each name I have a few other columns. What I need to do is notate in one of those latter columns if the name fits a set of criteria. What I want to have happen is have a list of those names populate in another tab in the spreadsheet based on the notation I made in the respective columns. I've attached the spreadsheet so you can visually see what I'm talking about. Thanks!
Re: Sorting function needed
Posted: Wed Mar 04, 2015 2:35 am
by coray80
Do the x's have to be placed manually or can they be created by a formula?
ie IF(a1 =criteria1;"x";"") if this is so use ROW() instead of "x" and INDEX/SMALL in criteria tabbed sheets.
Re: Sorting function needed
Posted: Wed Mar 04, 2015 2:36 am
by awascholl
They have to be placed manually.
Re: Sorting function needed
Posted: Wed Mar 04, 2015 2:59 am
by coray80
If the row no's are put in manually instead of the x's then the master sheet doesn't have to be done but the other sheets can use the INDEX/SMALL
Re: Sorting function needed
Posted: Wed Mar 04, 2015 3:11 am
by awascholl
The x's are necessary.
Re: Sorting function needed
Posted: Wed Mar 04, 2015 5:44 am
by MrProgrammer
awascholl wrote:Sorting function needed
Don't you mean "Filtering function needed"? You can filter
and sort, but your example doesn't show the need for sorting.
awascholl wrote:What I want to have happen is have a list of those names populate in another tab in the spreadsheet based on the notation I made in the respective columns.
It would be much easier to use one sheet and Data → Filter → Autofilter. This is the way spreadhseets are designed to work. But if you think you need separate sheets see
[Tutorial] Sorting and Filtering data with formulas. I built the formulas in the Criteria 1 sheet, then just copied that sheet to make Criteria 2 and Criteria 3 since the formulas in the attachment below adjust automatically.
If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Re: Sorting function needed
Posted: Thu Mar 05, 2015 1:56 am
by awascholl
Yes, this is perfect!! Thank you so much - I always have a hard word finding the right words to match what's in my head. Thank you to both you and coray80 for helping me out.