| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 110507 | 2010-06-20 04:49:00 | Excel 2003 help please... Dropdown Box | John W (523) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1111692 | 2010-06-20 04:49:00 | Hi there Ive a table with 11000 or so rows, containing repeated data from approx 200 suppliers. Id like to be able to add a Dropdown Box so I can select one supplier and view rows pertaning to them. But, Im having trouble doing this. I can create a Dropdown box, but it displays every supplier without distinguishing unique supplier names. i.e. Telecom NZ is listed say 200 times on the column and as many times in the dropdown box, when I only want them there once. Ive Office 2003, but I would like to do this in Excel 95 if possible. Thanks - John in Mosgiel. |
John W (523) | ||
| 1111693 | 2010-06-20 06:33:00 | Data / Filter is the tool I was wanting. Took a while to find the term. |
John W (523) | ||
| 1111694 | 2010-06-21 01:25:00 | Data / Filter is the tool I was wanting. Took a while to find the term. Have a look in help for AUTOFILTER |
ManUFan (7602) | ||
| 1111695 | 2010-06-21 01:31:00 | Try pivot tables - it's the best for repeated groups/suppliers (i.e. labels), and if their are related several data columns or rows. Though a bit daunting at first, but can quickly create grouped total stats summaries in different combinations... | kahawai chaser (3545) | ||
| 1 | |||||