cities

Hello, I have (i) a column in which each cell contains all of the cities in which companies have offices, and (ii) a column of specific cities that I'd like to count, if they occur in each cell. In less abstract terms, what i am trying to do is find out how many international offices each...

I have seen a few threads on this but I cannot get any of the formulas to work for me. In cells A1:A100 I have various cities. In cell b2 is today's date. In cell c2 is 1 year ago. I then have a "data" tab that has all these cities and data by month. The dates in the data tab are in cells...

HI, I want to transfer data from one sheet to another sheet. The data in the main sheet has several tables and i need all data on the next sheet in terms of cities and corresponding variables.

Hello, Column A is a large list of cities more than 10k duplicated city names, I need to list the names without duplicate. Preferable with formula only.

Hi folks, I have a list of 5 products and each of the 5 products are produced in 2 different cities, with sales in each city (the cities aren't really important for the solution, just FYI). 5 of the cities (or 50% of the cities) are in a column called Region 1 and the remaining 50% are in...

Help me solve it without adding any helper cells or changing the structure There are 8 cities in the country of Eight, A, B, C, D, E, F, G and H. Mr. Z decides to visit each city in his car starting from A. His planned itinerary is A-->B-->C-->D-->E-->F-->G-->H. The distance between the cities...

Sorry if the title is confusing, I'm not sure how to describe it. Basically, I need some homework help. The table is costs related to airplane tickets from and to different cities. The problem states that I have to start and end in new York, one of the 6 cities, and must visit each of the...

Hi, I'm trying to plot a scatter chart and need to know how to label each coordinate.. I have the following problem. I have different regions, Middle East, Asia, Europe.. I have a number of cities in each category (upto 20) and the number of cities keep changing based on input.. I have a...

Hi, I'm trying to create a drop down list with value changing in excel 2013. Basically the goal is when I choose an option from the list, it changes it into a number. The drop down list will be in a column that represents cities. I want to define numbers to the cities so when I go to a cell...

Hi, This is my first time posting, so please excuse the clumsiness and poor formatting. In my job, I need to validate data before I can start anything. My biggest problem is that cities are often misspelled or entered in the short-hand way and origin/destination pair will appear twice because...

I need to implement some functionality that will show a map of for example Europe and dependent on a list of cities and values for the cities, have a marker placed on the map where the city is and the marker, say a grey circle, be a size relative to all the other values in the list. For example...

I have a excel data containing than 10000 rows in which world's continents name are listed in column "A", countries name in column "B", cities name in column "C" and growth rates in Column "D". Now issue is whenever I try to count the number of cities that come under "India", under "Asia...

I am trying to create a formula to populate the Geo Differential field after assessing criteria 1) is the annually salary within a range of X 2) is the city one of the cities provided in the list Any help is appreciated <tbody> <colgroup><col width="126" span="5" style="width:95pt">...

Hello, first this is an old version of Excel, it is 2003 SP3 but, I have never needed more than it can do, so I never upgraded it, so please keep that in mind, as I know options change from revision to revision I have a chart I am working on with one sheet called data and it is just a big...

Hello, I am trying to create a large loop that will reference my column called cities. I want the loop to refernce cities and put the state of these locations in a new column with the header state. My table is below. I have 5 different cities Memphis, Sand Diego, Seatle, Portland, and Charlotte...