×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

I created in Excel an Item Master l

I created in Excel an Item Master l

I created in Excel an Item Master l

(OP)
I created in Excel an Item Master list (column A).
Column B and on represent the model numbers with part quantity values. See sample below.

A         B         C        D        E         F
        model B   model C   model D model E  model F ...
p/nW    3                    7         3
p/nX              4          5         2         4
p/nY    1                              1         5
p/nZ    2         1          4                   1

Question: Is it possible to filter the contents of say
Model B as:

Model B
p/nW   3
p/nY   1
p/nZ   2

If it is, how would I accomplish this?

RE: I created in Excel an Item Master l

Sort of. The list above is would normally be generated as a crosstab query from a set of various tables.

Just typing the values in a format similar to above doesn't lend itself to filtering. Entering the data in related tables and writing a crosstab query would allow filtering as needed.



RE: I created in Excel an Item Master l

what you want to do is build a Pivot Table, that will give you the ability to do what you are looking for. You will have to play with it a little bit droping and moving the values around.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources