split a list into a list with the single entry items, and another with multiple entry items in excel
Posted on 2011-02-19
I use the filters on a regular basis in excel but this filter criteria is not a usual one. I am however using for this project excel 2003
I have an alphabetical list (A, B, C etc) that represents group of the same objects in a table. I would like to graph the single items groups in one colour and the multiple groups in another colour. For that purpose, I would like to make 2 new tables, one for the single item groups and the other for the multiple groups. I then need to filter the list for single itemed groups, and place that in the appropriate new table, then filter for the multiple itemed groups, and placed that filtered list in the other new table. From there I can run the vlookups and other formulae that I already have in place.
I somehow feel there will be a simple way to get about it, and have searched but without much results! I think pivot tables might do the trick but these tables are embedded in specific worksheets ( about 20 each), and the order needs to remain as is as it is a multiple user workbook!
Thanks you again! I have learned with this projects trick that I know I will definitely use again much much more!