Excel Question
Is there a way in which you can sort your columns into simlar names? For instance i have a bunch of similar addresses with different names, can i bunch the same addresses together?? Hopefully that makes sense. Thx in advance.
|
Are the addresses in the same cell as the names or different? If the addresses are in their own cells in a separate column you should be able to just select all of them and then assort either ascending or descending and get them in alphabetical order. Then the same addresses would be together.
Let me know if I am missing anything. I am an average Excel user so odds are when you come back somebody a little more handy will be here. I also am not on my computer with Excel so I am just going off the memory of what options there are. Also a little confused on if you are asking for more than I think you are. |
hmm. not sure what you're asking. Im sort of an excel geek (unfortunately)
|
i could probably do what you want, but i have no clue what you are asking
|
Quote:
123 Main St. 123 Main Street 123 main 123 MAIN STR. |
Quote:
|
Quote:
If it's a case of needing to group similar postal addresses Excel would not be the tool to use. Access or some other DB program would need to be used to query the data using the LIKE command with wild card, look up tables, etc. |
Quote:
|
Quote:
What he COULD do is create a "Zone" column. I guess that would depend on how many address he had but..... He could give each Region a number or letter. Then designate that number/letter to each address, then sort it by "zone" . |
Quote:
|
Open the VBE. Choose Workbook and the select view code. Insert
Code:
Sheet1.Cells.ClearContents Profits. |
Quote:
|
There is a concatenate function if you're needing to pull the addresses apart, but I don't remember much about it.
|
Quote:
|
Quote:
|
All times are GMT -6. The time now is 09:53 AM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.