I have a table that contains data that changes often. It has companies across the top and products down the left. Several companies product the same product in many cases, but not all of them. I have a drop down list of the product names. What I would like to happen is that when the product is selected, it will only display the names of the companies that produce that product, when then could be used to look up the number of products. Anyone have an idea of how to go about this? Thanks!
example chart.xls
Hi,
Whilst it could be done with a macro I can't help thinking you'd be better re-arranging your basic data and using a Pivot Table. See sheet 2 in the attached workbook.
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
One way is with Array Formula. See the attached.
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks