Forum Home
Press F1
Thread ID: 14562	2002-01-12 05:27:00	Excel functions - membership lists	Guest (0)	Press F1

Post ID	Timestamp	Content	User
30896	2002-01-12 05:27:00	I am the secretary of a club with several Categories of membership. (A,B,C etc) I have the member's names listed in alphabetical order on one spreadsheet and want these to automatically transfer to another sheet separated under their various categories. This can be done with the 'if' function (ie =if(sheet1a1='A',b1,0)- b1 being the members name and A1 the category of membership. However this means that there will be gaps in the list because of the predermined position. Is there a function that will eliminate the gaps? Thank's Tom Erikson	Guest (0)
30897	2002-01-13 10:38:00	You could do it manually by using Data/Filter/AutoFilter on the list categories then copying the results to the appropriate place. A function won't do this - but a macro could.	Guest (0)
30898	2002-01-15 21:08:00	I'm not sure whether there is an automatic way of removing blank rows but the quickest manual way would be to do a sort on the new info which will put all the blank lines together - quicker to delete in one group.	Guest (0)
1