Forum Discussion
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#
A is Description, C is Batch # , D is Tub#
As you see they are mixed and it is a large SS. Pleae Help.
Formulas and Functions
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.
