city

  1. L

    Conditional Format formula

    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...
  2. K

    Excel Formula: Getting the city name - non-US

    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...
  3. D

    Selection from drop down box

    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...
  4. L

    Power Query to Concatenate Rows Based on Condition

    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...
  5. Penguinducky

    Extracting City and State from a cell without commas

    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...
  6. Z

    Linking Forms to another Forms

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

    What is wrong with my select case statement

    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...
  8. E

    SUMPRODUCT / INDEX MATCH Question

    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...
  9. smide

    Conditional formatting - highlight previous appearance

    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...
  10. N

    Separating City from Address When Only Comma Sits Between City and State

    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...
  11. T

    Formula to extract City, State & Zip from address

    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...
  12. N

    vloop or code - entire row

    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...
  13. S

    Formula Too Long

    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...
  14. V

    Forms using Data

    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...
  15. Nelson78

    VBA, Arrais and Dict: combine duplicate rows and sum the values

    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...
  16. T

    Top 5 based on selection from drop down - index/match??

    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...
  17. L

    GoogleSheets Data help Required

    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...
  18. D

    Cross Tabulation

    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...
  19. Nitehawkhp

    Error 91 when trying to execute VBA code to find and replace data

    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...
  20. L

    quick way to do Go Special-->Column diff

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

Some videos you may like

This Week's Hot Topics

Top