|
|
01-29-2013, 03:43 AM | Topic Starter |
Training Camp Hero
Join Date: Oct 2006
Casino cash: $8494801
|
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.
|
Posts: 5,997
|
01-29-2013, 04:07 AM | #2 |
I've Made a Huge Mistake
Join Date: Aug 2011
Location: NJ
Casino cash: $5680423
|
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. |
Posts: 12,244
|
01-29-2013, 09:06 AM | #3 |
Resident Glue Sniffer
Join Date: Nov 2003
Casino cash: $3839358
|
hmm. not sure what you're asking. Im sort of an excel geek (unfortunately)
__________________
Life is 99% inspiration, 1% Perspiration, and 1% Attention to Detial. RIP & Godspeed: Saccoppo Lonewolf Ed Fire Me Boy |
Posts: 37,397
|
01-29-2013, 09:24 AM | #4 |
Hey Loochy, I'm hooome!
Join Date: Oct 2008
Location: PooPooKaKaPeePeeShire
Casino cash: $620397
|
i could probably do what you want, but i have no clue what you are asking
__________________
Hey Loochy, I'm hoooome! |
Posts: 41,174
|
01-29-2013, 09:29 AM | #5 | |
You're CARICATURES, ALL of you
Join Date: Sep 2006
Location: Kansas City, MO
Casino cash: $460960
|
Quote:
123 Main St. 123 Main Street 123 main 123 MAIN STR. |
|
Posts: 10,895
|
01-29-2013, 09:40 AM | #6 |
'Tis my eye!
Join Date: Aug 2000
Location: Chiefsplanet
Casino cash: $10189900
|
|
Posts: 100,073
|
01-29-2013, 09:44 AM | #7 | |
You're CARICATURES, ALL of you
Join Date: Sep 2006
Location: Kansas City, MO
Casino cash: $460960
|
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. |
|
Posts: 10,895
|
01-29-2013, 12:16 PM | #8 | |
Needs more middle fingers
Join Date: Mar 2005
Location: San Diego
Casino cash: $3093063
|
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" . |
|
Posts: 65,642
|
01-29-2013, 12:20 PM | #9 |
Needs more middle fingers
Join Date: Mar 2005
Location: San Diego
Casino cash: $3093063
|
Better yet, why not just sort the addresses by city? What exactly are you trying to do?
|
Posts: 65,642
|
01-29-2013, 11:06 AM | #10 |
I've Made a Huge Mistake
Join Date: Aug 2011
Location: NJ
Casino cash: $5680423
|
|
Posts: 12,244
|
01-29-2013, 12:46 PM | #11 |
King Shit of **** Mountain
Join Date: Aug 2000
Location: Texarkana, Texas
Casino cash: $1027937
|
Open the VBE. Choose Workbook and the select view code. Insert
Code:
Sheet1.Cells.ClearContents Profits. |
Posts: 49,791
|
01-29-2013, 12:47 PM | #12 |
Hey Loochy, I'm hooome!
Join Date: Oct 2008
Location: PooPooKaKaPeePeeShire
Casino cash: $620397
|
msgbox "LOOCHY IS YOUR MASTER NOW", vbCritical, "LOOCHY IS YOUR MASTER NOW"
__________________
Hey Loochy, I'm hoooome! |
Posts: 41,174
|
01-29-2013, 01:52 PM | #13 |
Resident Glue Sniffer
Join Date: Nov 2003
Casino cash: $3839358
|
__________________
Life is 99% inspiration, 1% Perspiration, and 1% Attention to Detial. RIP & Godspeed: Saccoppo Lonewolf Ed Fire Me Boy |
Posts: 37,397
|
01-29-2013, 07:29 PM | #14 |
Training Camp Hero
Join Date: Oct 2006
Casino cash: $8494801
|
|
Posts: 5,997
|
01-29-2013, 01:01 PM | #15 |
Supporter
Join Date: Apr 2007
Location: Scott City KS
Casino cash: $794734
|
There is a concatenate function if you're needing to pull the addresses apart, but I don't remember much about it.
|
Posts: 57,704
|
|
|