city

I would appreciate any help with the following. A1 contains the name of a city say Reading. F1 contains a mnemonic for that city which in this case is logically RE. However the RE is not always the only letters in the cell. So what I need is a CF formula that will check if the first 2...

Hi all, First and foremost, I want to thank who will help since I'm new with excel's formula Here is my data: SM NORTH EDSA PAG ASA 1, QUEZON CITY, 1105 4390 DAYAP COR. CUENCA STS., BRGY., PALANAN, MAKATI CITY RM 313 LAPERAL BLDG. SESSION ROAD, BAGUIO CITY I just want to extract the city...

I have a drop down box on a sheet called Start_here with 2 options and each option is a town. When the option is selected and a Continue button is pressed I need a header and footer to be loaded onto the sheet quote_sheet depending on the town selected. The headers and footers are images...

Hi, I have column with Names, (unique) ID, and Address. The problem is some addresses have their street address in one row and the row below it is their city, state and zip. I would like to have their street address, city, state, and zip in concatenated in on line based on their ID. For...

Trying to extract the City and State from a cell that has the Name of the Company, City and State in it and I only want to show the location. Problem scenarios I'm having: City and State are mushed together (example: MissssaugaOntario) Company name and city have a / or - between them (example...

My Boss asked for a hard task ( for ME) which requires To create a form and inside the form create a Combo Box where i can open a drag down menu and select an option and this option Automatically fill another form Linked to this one. For an example: Form 1 Contains the city, if i choose a...

This is the start of my select case statement and it has an error and I can't figure out why, can someone help me please? Dim printWorksheet As Worksheet, logoShape As Shape, tempImageFile As String Dim city As String Set city = ThisWorkbook.Worksheets("Start_here").Range("H9").Value...

Hello, I'm trying to use a sumproduct formula to pull in data from a table with 3 criteria, but I need one criteria to reference a table. Here's an example of what I'm trying to do. I'm trying to pull how many apples Chris sold in each state. Sheet 1 <colgroup><col...

Hello. In column A (A3:A600) I have a customer names and in column B (B3:B600) customer's cities (their current location). In cell C3 there is a 'referent city'. When customer is in 'referent city' I need to highlight his previous appearence (column A). example. <tbody> A B C 1...

Looking to extract the City from an address (which can be more than one or two words (ex: Winter Garden or Miami). The format I have is as follows: Address [space] City [comma] State Abbv [Space] Zip examples below: 6615 Mahan Dr Tallahassee, FL 32308 3838 S Dale Mabry Hwy Tampa, FL 33611 999 E...

I have a series of addresses that are in the following format: 273 Winding Road Boyertown OH, 19512 16 Penn Lane Wayne PA, 19087 519 Conshocken State Rd Happy Valley PA, 15208 What separates the city from the address line is two spaces. I'm trying to figure out how to pull the City, State...

Hello All, So I have office locations in sheet 1 as follows: <tbody> Location Address City State Zipcode Chicago 243 W Jackson Chicago IL 60605 New York 505 W 50th St New York NY 10019 Los Angeles 20 Calabasas Road Los Angeles CA 98490 </tbody> Now I m looking to auto populate data...

Hi, I am quite new on Excel and I am trying to create a Formula which is some kind of a database. I want to create an autofill of time between 2 locations that I will pre-set... In the first line for ex. IST is city code and BKK is city code, if I insert these 2 city codes the value of 2 hours...

All - I currently have a drop of data with 3000 rows and 26 columns of data that I need I need to filter based off a certain city within the data Would like to create a summary form with the cities and when I click on the certain city it would then show me all the info for the pertain rows and...

Hello everybody. I have a table in the following range: Worksheets(1).Range("A2:R" & lr2 + lr3 - 3) Having column A as a reference point (it is a list of cities), if the same city is repeated, I've to sum all the value in column in order to produce only a row for any city. Then overwrite...

Hi, I have my workbook set up to show a separate worksheet for each city. The representative from each city will go into their own city worksheet and select their city from a drop down list. When the city is selected, I need to bring in top 5 past due invoices for that city - data set is on a...

Hello, I am currently facing a problem as to how to add data of different names under same column in a new cell in a different sheet on google excel spreadsheet? or an example: column X has names of city,column Y has a value corresponding to each city in X, how do i add values of city A,city...

Hi All, I have a question on what you think would be the best way to solve a problem that I have... I have attrition numbers for 12 months in columns and City_Tenure in the Rows, it looks something like this.... <colgroup><col><col><col><col></colgroup><tbody> Code ATTRITION_Jan_18...

Greetings, I'm trying to author a VBA script that will find information in column G based on criteria found in column N and replace the information in column G with the information in column O. Here's a snipit of what my worksheet looks like: <tbody> F G H N O Date Description Amount Find...

Hi I have long column which look like the one below. I want to go to next city fast, so I want to use Go to Special. I tried the following Ctrl + G then Alt + S then Alt +m Ok I can go to next city but how about going to next city, if i repeat all steps above that is slow? I was thinking I...