city

Hi everyone. I've searched through the forums and haven't found exactly what I'm looking for just yet so I thought I'd ask. How could I rank projects based on items, age, city (city is given a number) for example A B C 5 73 Portland 13 2...

Hi, I have an address the following formats in a cell: Customer Name, 1 Address, 2 Address, City, ST, 00000-0000, US Other Customer, 1 Address, City, ST, 12345, US I need a formula to just extract the “ST” state information. My problem is sometimes there is no “2 Address” and...

I have two Tables in two sheets: Table 1 contains the list of all cities Table 1 <tbody> Pakenham Point Cook Ocean Grove Melbourne Dianella </tbody> Table 2 Contains the Data - the string from which the City has to be separated from address To Note: The city Name may be a single...

Hi All, I am facing a peculiar problem. I want to lookup for a text string in the rows, match a particular number in the values of that row, and then return the column header to which it matches. Below is a sample data: <tbody> Address ABC DEF GHI JHL MNO Ayala Alabang Village, Muntinlupa...

<tbody> A B C D E F G H 1 Country K Country City Type K 1 2 2 City 1 Afghanistan Kabul Post 1000 2000 3000 3 Kids 2 Afghanistan Kabul Away 4000 5000 6000 4 Location Chile Santiago Post 7000 8000 9000 5 Chile Other Post 10000 11000 12000 </tbody> Morning everyone, I'm working an...

I am trying to take multiple rows and bring them to one row. for example I am trying to take address, City, State, and country and bring them to one column that has them all read. I cant use a concatnation excel formula becasue I need there to be spaces between address city state and country. An...

If I want to select a group of people in a state and do reports by city and list them by first and last names with their address, and zip code, is pivot table the way to go or should I just sort them by city and then make separate worksheets by city?

I NEED :help:TO SEPARATE FULL ADDRESS IN DIFFERENT COLUMS OR COMMAS: Example: THE WAY I HAVE THE DATA IS LIKE THIS: <tbody> <tbody> THIS IS THE WAY HAVE THE LARGE DATA ADDRESS CITY STATE ZIP 9737 NW 41 ST SUITE 182 DORAL, FL 33178 <tbody> 19737 Carabana st. Fort Myers, FL 33901...

I have a list of area codes and match up with cities listed as such: column K: area codes column L: cities column C: where im entering the city manually for each client What I am wonder is how to type a city into column C and have it sift through my areacode/city table and output the area...

I have excel and MapPoint...in excel I have lat/long and want to convert to get the city, state, zip in different cells. Is this possible? How have found options to convert city, state, zip into lat/long but not reverse. Thanks for any help! M