Forum Discussion
Solved
Help with data fields
I am trying to take data from Tub field (#) and pull all tub# that = # and get all text data that matches Tub# . I want to export or create a New Spread Sheet with all items contained for that tub# ...
Actually, it occurs to me that if you are not in a position to upgrade to the more current version of Excel, you may be almost as well served by just doing this filtering manually. Are you aware of the tool bar selection, under "Data" called Filter? I've highlighted the section of the tool bar here in this image.
What that does is give you the ability to "manually" filter the data in a table such as yours by selecting the value you want to use.
Notice the little "filter" symbol in the header row. I've used it to select "1" under TUB #, and that filters the entire table so that only the rows with "1" in that field are shown.
Notice the row designations along the left side: there are rows missing now, rows that contain other Tub# values.
You can then copy them manually to a separate sheet, as I've done in the attached file. This is nowhere near as efficient as the FILTER function, which operates dynamically and in real time.....but if your need is to get occasional extracts like this, it may serve you adequately.
I'm finding it very difficult to understand what you've written. The words are clear; it's the concept, the references, that are confusing. You've got duplicate column heads in different tables, a fact that adds to the confusion.
So I'd encourage you to:
- Write a clearer, less ambiguous, description of the task at hand.
- Research the FILTER function (here's a link)(here's another link😞 I do believe, even without understanding the details of your request, that this FILTER function would be part of the solution, if not the whole solution.
And come back if you need further help, after working to clarify the task.
I tried you FILTER suggestion.... But I am unable to get errors #Value to correct
I want to create new workbook with all D2 numbers (By Tub #) with showing all items in A to show
As you can see below , D2-D## are mixed (As they should be per data entry)
EXAMPLE Concept: If D2 to D37 = 1 then list all contents of A
I desire it to pull all same TUB# with the Product descriptions, There are a total of 9 tubs btw.
All of "PULLED" data on new SpreadSheet would be best.
Tub List with Contents
Posting only an image shows me the data, but requires me to enter it all afresh in order to test a formula. Would you be so kind as to post a copy of your actual spreadsheet on GoogleDrive or OneDrive, and paste a link to that spreadsheet here so I and others can access the actual spreadsheet.
Also let us know what version of Excel, and what operating system, you are working with. It may be that FILTER requires a newer version of Excel than you have. Otherwise, it should work if the formula is entered correctly.
- Sorry didn't mention in post with file..
Win10 Excel 2019 I dont usually use ONEDrive but here it ishttps://1drv.ms/x/s!AjVFdakG-bRlfFJ0N_azcoyREio?e=anAGaE
Look forward to an awnser.
I do desire to create a NEW sheet when compliling this sorted data so not to corrupt my original listing.
Thanks for your help to you and everyone!
First some bad news: You'll need to upgrade to Excel 2021 to get the FILTER function to work. That is probably why it didn't work for you.
Then the good news. I think it would be worth it for your organization to upgrade. If it's not possible, please come back and let me know. There are functions in the older version of Excel that could also work, but less easily.
The FILTER function, as I expected, works easily. I've attached a copy of your workbook.
- In it you'll find a new tab named "Filtered."
- On the "Filtered" sheet there is a cell (H2) where you can select a Tub#
- Then on the left, all of the entries corresponding to that Tub# will appear.
Here are several examples. First, for Tub #1 (the list continues below the image shown)
Here for Tub #2
Finally for Tub #3 (you'll be able to do each tub; these are just examples)