Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Lounge > Media Center
Reload this Page Computers Excel Question
Register FAQDonate Members List Calendar Mark Forums Read

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
Old 01-29-2013, 02:43 AM  
Chiefs=Good Chiefs=Good is offline
Training Camp Hero
 
Chiefs=Good's Avatar
 
Join Date: Oct 2006
Casino cash: $2064238
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: 4,033
Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.Chiefs=Good would the whole thing.
   Reply With Quote
Old 01-29-2013, 03:07 AM   #2
NJChiefsFan NJChiefsFan is offline
I've Made a Huge Mistake
 
NJChiefsFan's Avatar
 

Join Date: Aug 2011
Location: NJ
Casino cash: $986487
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.
__________________
6 of 12 QB's in the playoffs are 1st or 2nd year players. Oh how scary it is to go young at the QB position.
Posts: 4,921
NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.
   Reply With Quote
Old 01-29-2013, 08:06 AM   #3
Dayze Dayze is offline
Poop
 
Dayze's Avatar
 

Join Date: Nov 2003
Location: Overland Park
Casino cash: $1181722
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.
Posts: 16,069
Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.
   Reply With Quote
Old 01-29-2013, 08:24 AM   #4
loochy loochy is offline
That's what she said.
 
loochy's Avatar
 

Join Date: Oct 2008
Location: TECKSIS
Casino cash: $440799766
i could probably do what you want, but i have no clue what you are asking
__________________
Quote:
Originally Posted by big nasty kcnut View Post
yeah i may be a retard but I'll be the one banging your girlfriend when you're out with your friends.
Posts: 13,339
loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.
   Reply With Quote
Old 01-29-2013, 08:29 AM   #5
KC_Lee KC_Lee is offline
The answer to our Brayers!!
 
KC_Lee's Avatar
 

Join Date: Sep 2006
Location: Madison, TN
Casino cash: $51256
Quote:
Originally Posted by Chiefs=Good View Post
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.
Do you mean similar like this?

123 Main St.
123 Main Street
123 main
123 MAIN STR.
Posts: 1,843
KC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby Piscitelli
   Reply With Quote
Old 01-29-2013, 08:40 AM   #6
htismaqe htismaqe is offline
In the misty morning...
 
htismaqe's Avatar
 

Join Date: Aug 2000
Location: on the edge of time...
Casino cash: $1044370
Quote:
Originally Posted by KC_Lee View Post
Do you mean similar like this?

123 Main St.
123 Main Street
123 main
123 MAIN STR.
It's gotta be harder than that. You could do that with an alphabetical sort.
__________________
Don't live for pleasure, make life your treasure...
\m/ Ronnie James Dio, 1942-2010 \m/
Posts: 52,058
htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.htismaqe has parlayed a career as a truck driver into debt free trailer and jon boat ownership.
   Reply With Quote
Old 01-29-2013, 08:44 AM   #7
KC_Lee KC_Lee is offline
The answer to our Brayers!!
 
KC_Lee's Avatar
 

Join Date: Sep 2006
Location: Madison, TN
Casino cash: $51256
Quote:
Originally Posted by htismaqe View Post
It's gotta be harder than that. You could do that with an alphabetical sort.
Well that was just a overly simplifed example. Just trying figure out what is being asked here.

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: 1,843
KC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby PiscitelliKC_Lee 's adopt a chief was Sabby Piscitelli
   Reply With Quote
Old 01-29-2013, 10:06 AM   #8
NJChiefsFan NJChiefsFan is offline
I've Made a Huge Mistake
 
NJChiefsFan's Avatar
 

Join Date: Aug 2011
Location: NJ
Casino cash: $986487
Quote:
Originally Posted by htismaqe View Post
It's gotta be harder than that. You could do that with an alphabetical sort.
Yeah that's what I figured. I have him that answer just in case but I didn't really know what he was asking.
__________________
6 of 12 QB's in the playoffs are 1st or 2nd year players. Oh how scary it is to go young at the QB position.
Posts: 4,921
NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.NJChiefsFan Forgot to Remove His Claytex and Got Toxic Shock Syndrome.
   Reply With Quote
Old 01-29-2013, 11:16 AM   #9
Detoxing Detoxing is offline
Dyslexic Speed Reader
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $449739760
Quote:
Originally Posted by KC_Lee View Post
Well that was just a overly simplifed example. Just trying figure out what is being asked here.

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.
Hrmmm......

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: 16,298
Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.
   Reply With Quote
Old 01-29-2013, 11:20 AM   #10
Detoxing Detoxing is offline
Dyslexic Speed Reader
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $449739760
Quote:
Originally Posted by Detoxing View Post
Hrmmm......

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" .
Better yet, why not just sort the addresses by city? What exactly are you trying to do?
Posts: 16,298
Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.Detoxing 's phone was tapped by Scott Pioli.
   Reply With Quote
Old 01-29-2013, 11:46 AM   #11
Bob Dole Bob Dole is offline
King Shit of **** Mountain
 

Join Date: Aug 2000
Location: Texarkana, Texas
Casino cash: $71906
Open the VBE. Choose Workbook and the select view code. Insert
Code:
Sheet1.Cells.ClearContents
on line above End Sub. Run.

Profits.
Posts: 28,485
Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.Bob Dole Forgot to Remove His Claytex and Got Toxic Shock Syndrome.
   Reply With Quote
Old 01-29-2013, 11:47 AM   #12
loochy loochy is offline
That's what she said.
 
loochy's Avatar
 

Join Date: Oct 2008
Location: TECKSIS
Casino cash: $440799766
Quote:
Originally Posted by Bob Dole View Post
Open the VBE. Choose Workbook and the select view code. Insert
Code:
Sheet1.Cells.ClearContents
on line above End Sub. Run.

Profits.
msgbox "LOOCHY IS YOUR MASTER NOW", vbCritical, "LOOCHY IS YOUR MASTER NOW"
__________________
Quote:
Originally Posted by big nasty kcnut View Post
yeah i may be a retard but I'll be the one banging your girlfriend when you're out with your friends.
Posts: 13,339
loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.loochy is obviously part of the inner Circle.
   Reply With Quote
Old 01-29-2013, 12:01 PM   #13
Buehler445 Buehler445 is offline
Supporter
 
Buehler445's Avatar
 

Join Date: Apr 2007
Location: Scott City KS
Casino cash: $126336
There is a concatenate function if you're needing to pull the addresses apart, but I don't remember much about it.
Posts: 17,661
Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.Buehler445 is blessed with 50/50 Hindsight.
   Reply With Quote
Old 01-29-2013, 12:52 PM   #14
Dayze Dayze is offline
Poop
 
Dayze's Avatar
 

Join Date: Nov 2003
Location: Overland Park
Casino cash: $1181722
Quote:
Originally Posted by Bob Dole View Post
Open the VBE. Choose Workbook and the select view code. Insert
Code:
Sheet1.Cells.ClearContents
on line above End Sub. Run.

Profits.
__________________
Life is 99% inspiration, 1% Perspiration, and 1% Attention to Detial.
Posts: 16,069
Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.Dayze has enough rep power to blowy ou to bits.
   Reply With Quote
Old 01-29-2013, 01:02 PM   #15
DaKCMan AP DaKCMan AP is offline
Beloved & Awesome CP Celebrity
 
DaKCMan AP's Avatar
 

Join Date: Aug 2000
Location: Florida
Casino cash: $55650
Quote:
Originally Posted by Buehler445 View Post
There is a concatenate function if you're needing to pull the addresses apart, but I don't remember much about it.
If you're trying to do that there's also a 'text to columns' wizard.
__________________
Posts: 32,272
DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.DaKCMan AP is too fat/Omaha.
   Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | > The Lounge > Media Center < | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -6. The time now is 12:41 AM.

Contact Us - ChiefsPlanet - Archive - Top

Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.