List items in column
I'm sure there must be a way of doing this ...
I have 2 columns of data, with around 2,000 entries in each. Items in Column A tend to be one from a list of c 10 different variables, whereas Column B contains maybe 300 variables. I need to produce a simple list that shows when Column A = "x", what the possibilities are in Column B. This is easy to achieve using Auto Filter - just filter Column A and then the drop-down list on B shows the various possibilities. But how can I get this to show on the worksheet somewhere? Obviously I can sort by A then by B but this then produces many rows of data - all I want is a 'summary' list. Thanks. |
List items in column
Possibly look at doing a pivot table report of column a and B as row headings Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=562055 |
All times are GMT +1. The time now is 03:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com