I have a sheet that has my customer list in the first column. Each customer has 9 rows of information associated with it. I want to sort my customers alphebetically but when I do that they all get grouped together and none of the associated information in the 9 rows associated with each customer is sorted with it.
Originally I had the 9 rows merged for one cell for the customer but i cant sort cells of different sizes!
Please help.
Jess
depends of your exact layout but you can use/adapt this method
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Even by doing this, when I choose column A and try and sort it alphebeticall it still sorts it and puts the new sorted list in rows A2 A3 A4
I want them sorted but still keep them in the original cells....A2 A11 and A20
need to see your original , what i showed was for that specific type of layout one name 9 rows of associated data
I have attached my spreadsheet since I dont think I have described what I want to do very well.
that sheet doesnt show a list of customers with 9 rows of info! its some sort of price list
It is a customer recommendation program list...so Column A and B is the customer and column C is the new customers that were referred by him. The rest is the hours accumulated and used within the program. So I think I want to kinda group all this information together (for lack of the proper word) so that when I add the rest of the customers I can alphebetize the customers and still keep all the information with it.
oh no its not column a has part# so does col b
The Fastener Centre
Standard Grease Fittings
Part # PART # Description
2004 N641 1/4 - 28 Straight
2024 N698 1/4 - 28 Straight Long
2021 N612 1/8 NPT 67- 1/2 Angle
2019 N728 3/16 Drive Type Straight
2006 N637 1/4 - 28 45 Angle
Oh ****...must have attached the wrong list....SORRY
Here is the right one!
lol here it is done using same method i duplicated it and sorted look at sorted sheet
you must have the customer name in the first cell of each 9 i had to move allard from a6 to a2
YES!! That does work....Thank you so much.
BUT it doesnt look very pretty. Is there a way to do this without having to repeat the customer name?
just delete that when done or hide column
Thanks so much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks