Home Discord Chat
Go Back   ChiefsPlanet > Nzoner's Game Room > Media Center
Reload this Page Computers Excel Question
Register FAQDonate Members List Calendar

Reply
 
Thread Tools Display Modes
Old 01-29-2013, 09:44 AM   #1
KC_Lee KC_Lee is offline
You're CARICATURES, ALL of you
 
KC_Lee's Avatar
 

Join Date: Sep 2006
Location: Kansas City, MO
Casino cash: $1830960
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: 9,368
KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.KC_Lee is obviously part of the inner Circle.
     Reply With Quote
Old 01-29-2013, 12:16 PM   #2
ModSocks ModSocks is offline
Needs more middle fingers
 
ModSocks's Avatar
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $4174563
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: 64,435
ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.
     Reply With Quote
Old 01-29-2013, 12:20 PM   #3
ModSocks ModSocks is offline
Needs more middle fingers
 
ModSocks's Avatar
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $4174563
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: 64,435
ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.
     Reply With Quote
Reply

« Previous Thread | > Nzoner's Game Room > Media Center < | Next Thread »

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 04:17 PM.

Contact Us - ChiefsPlanet - Archive - Top

This is a test for a client's site.
Fort Worth Texas Process Servers
Covering Arlington, Fort Worth, Grand Prairie and surrounding communities.
Tarrant County, Texas and Johnson County, Texas.
Advertise with us!
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.