| Edit: Changed subject, was Sorting function needed Make your post understandable by others -- MrProgrammer, forum moderator |
[Solved] Filtering feature needed
[Solved] Filtering feature needed
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!
- Attachments
-
- Example.ods
- (10.1 KiB) Downloaded 105 times
Last edited by MrProgrammer on Thu Apr 06, 2023 7:51 pm, edited 2 times in total.
Reason: Edited topic's subject
Reason: Edited topic's subject
Re: Sorting function needed
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.
ie IF(a1 =criteria1;"x";"") if this is so use ROW() instead of "x" and INDEX/SMALL in criteria tabbed sheets.
Last edited by coray80 on Wed Mar 04, 2015 2:40 am, edited 2 times in total.
OpenOffice 4.1.2 on Windows 7
If your question has been answered please add [solved] to the title by using the edit button at your first post
If your question has been answered please add [solved] to the title by using the edit button at your first post
Re: Sorting function needed
They have to be placed manually.
Re: Sorting function needed
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
- Attachments
-
- Example(1).ods
- (13.02 KiB) Downloaded 110 times
OpenOffice 4.1.2 on Windows 7
If your question has been answered please add [solved] to the title by using the edit button at your first post
If your question has been answered please add [solved] to the title by using the edit button at your first post
Re: Sorting function needed
The x's are necessary.
-
MrProgrammer
- Moderator
- Posts: 5258
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: 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:Sorting function needed
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.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.
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.
- Attachments
-
- 201503032141.ods
- (9.7 KiB) Downloaded 97 times
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.5, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.7.5, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: Sorting function needed
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.