city

Hello, I created a macro in Access to run a query with a date parameter and a field that concatenates the city, state and zip fields. When the query runs and completes, I can see the concatenated field as I should and the city, state and zip are unchecked in the query to be invisible, but...

I have a table like the below, trying to find top 5 attendances using LARGE then INDEX/MATCH The issue I have is that in GameWeek1, two teams have the same attendance therefore the INDEX/MATCH brings the first one back twice. For example, in G1:G5 I have the numbers 1 to 5. In H1:H5 I have...

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 guys, Encountered with a problem where I have recorded macros to find out specfic values using vlookup. In Column, XEZ6192, there are partners, city and agents available that are linked with Column N2 and onwards. Now issue is whenever I add new partners down in Column XEZ, it always gives...

I put together a Vlookup to check concatenated value based on text and a certain date in two worksheets and return a value based on that. The lookup date is always the first of a month. The column it returns the value from has either "At Sea" or different cities in it. In many cases the value...

Hi All, Need a help in capturing data from another spreadsheet. I have two files 1. File A (1200 rows) <tbody> Name Exchange City Address1 Address2 State Country Postal Abe John CBOT New York Mark Twain CME Singapore </tbody> 2. File B ( 300 rows) <tbody> Address1 Address2...

I have 2 sets of data, for 2 indicators, over time. Format shown below (of course, the data sets are much bigger) Data set 1 (indicator A) <tbody> City 2009 2010 2011 2012 2013 2014 2015 2016 2017 Airdrie 1 2 3 4 5 6 7 8 9 Brooks 9 8 7 8 4 2 1 2 5 Calgary 4 7 4 3 4 8 7 6 1 Duncan 7 5 6...

I have 3 column Column A has different City Name Column B has name of Person Column C has Phone numbers Need a VBA code that can select city name that has phone numbers count greater than 500 , and delete number count that are greater than 500 , For example : City London has Phone number...

Hi guys! Happy New Year! I have a little problem. I have 2 columns with adresses and cities. Almost always there is a street number with street name in column H and City in column J. But not always. Sometimes a little village do not have street names, just numbers and I need to merge that...

Hi All, I`m looking trying to code my script for Excel, I have a Data set that looks like this <tbody> Country City Dollar Notes Hello Country City Dollar Country City Dollar Notes Hello </tbody> What I want to do is go through all my data. If I find something...

Hello, I am struggling with this formula. I was using index function, maybe I shouldn't be. I have an online form that people can put their store numbers in and submit commissary issues. I want to keep that form short. So on the back end, I want to fill in the City, State etc. columns by...

I have a problem that I'm not sure can be solved in a simplified manner. What the code below is doing: Takes the LEFT 3 characters on sheet1 (airport code) and looks up the airport code in sheet2 and returns the 2nd column (city). Before returning TRUE or FALSE, it tries to see if the first 4...

Hello all. Working with an in-depth spreadsheet. I have one cell that contain CITY STATE ZIP and I canny split. I’m running a macro that will proper case my cells. However, on the cell with City State Zip - my state abbreviation goes from FL to Fl. Is there a macro I can run again to change the...

Hi Folks, So I have an macro code which searches through "column C" for specific keywords and moves it to "Sheet2" the whole row if it matches the keyword. Example: I made the code to move the whole row if there is a keywords such as "town, county, city, state, etc" I did this because I have...

Hi, I would like to classify the CITY in an unstructure Address Column in Sheet1 - i have the City table - with ALL CITY NAMES (standard reference table) in Sheet 2 - I have the data i need to parse and classify Requirement - To compare with the city table and assign the numbers based as...

Hi Excel 2013 I have a list of 4422 addresses where the city name is suffixed at the end of the address. The problem is that there is no delimiter in front of the city names and the number of words in the City Name varies between 1-3 How could I split them up so that the city is in a new...

Hi,I am very new to macros and in need of solution please. So I have over 140,000 rows of data in which column "C" has specific keyword(s). I would like to create a macro in which find if it does contain these keywords it would copy it to another spreadsheet. Example: Column C might say...

Dear All, I am working on google sheet with loads of rows and columns. I have to summarize the results of main sheet into summary sheet. Main sheet contains many columns like Name, email, phone, city 1, city 2, city 3. In summary sheet I have to give total numbers of city 1, city 2 and city...

Good afternoon all, i have an extensive list that i am trying to break down to multiple tabs. where row g is item group and row k is city. I would like it to copy to sheet 2 all of the lines in item group 100 for city anytown then copy to sheet 3 all of the lines for group 300 city anytown and...

I have data exported from a POS that is listed downways with common Invoice number. What i need is to have it listed on a single row for each invoice. Current data <tbody> District Invoiced At Sold On Invoice # Sold By Customer Product SKU Product Name Tracking # Refund Qty Gross Profit...