city

Example I have multiple addresses similar to the below. I need to insert a comma 10 spaces to the left (after the city) so that I can use the delimeted to break it out into separate columns for city, state, zip (there is currently no comma after city) Cleveland oh, 45120 e Rutherford nj, 06034...

Hello, I would like to ask for your kind support in solving my not so easy problem. Given City A – City Z distance in miles (one way, by car) City Z – City A distance in miles (the other way, bytrain) Ask: For any given city pairs, find 1. If the A2Z has a counterpart Z2A 2. If there is one...

Hi I am trying to retrieve data from a separate sheet based on cell value. Eg In my summary sheet Column A has client names I then have separate sheets - one for each client. If Cell A1 Contains A Client Called "Big City" In Cell B1 I want to show data from Cell F6 in a sheet called "Big...

HI I have a pivot table with a slicer for city. I want to be able to set and block the slicer to specific city depending on the <code style='margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit...

I am using this formula =IF(E2<>"",INDEX(TRAVEL!$B:$H,MATCH(E2,TRAVEL!$F:$F,0),4),"") but the city is not found so I am getting a #N/A how do I get rid of it?

I have a workbook that has over 25,000 contacts that includes Name - Email - Phone Number - Location - City - Role. I am currently using a indirect list validation to sort between Location - City - However Roles are not filtered by City - they are filtered by location... This leaves roles...

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

I have a list that looks like: <tbody> Address 1820 E River Rd Ste 230Tucson 7550 E Mcdonald Dr Ste AScottsdale 442 Kaleimamahu StHonolulu 6 Larch Ave Ste 398Wilmington 85 Willow StNew Haven 64 Thompson St Ste A105East Haven PO BOX 2590416 Slater RoadNew Britain 7059 Blair Rd...

I have a file with all the state and cities that I need. I want to match the population of the US census dataset to the cities in my list but the cities are not in the same format. This task would be easy if there weren't multiple cities that show up in different state. What I want the formula...

I have two columns, I want to search for the cities in the 2nd column and highlight those cities in the 1st column. <colgroup><col><col></colgroup><tbody> ARBYRD MO ARBYRD MO ARBYRD MO HORNERSVILLE MO ARBYRD MO COOTER MO ARBYRD MO HOLLAND MO ARBYRD MO CARDWELL MO AVA MO RIVES...

I am sure my title is not correct on what I need to do. OK, I have a spreadsheet (work book) that has 2 sheets in it. Points has city and miles. <tbody> <tbody> Points Miles MEMPHIS TN 13 GERMANTOWN TN 18 BARTLETT TN 22 CORDOVA TN 24 COLLIERVILLE TN 27 MILLINGTON TN 29 EADS TN...

Hi I want a user to enter city name is cell H1 then excel will return the row number using Match(). What to do in case we have the lookup value matching many in a column. Thank you. Enter city name H1= Toronto <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> name...

Hi Can I create multiple list. For example a list like this XXXX ---> {it, hr, marketing, sales} XXXX {name, dept, salary, city} if user select dept then list of dept will show, if user select Name, then list of names will be listed, if user select Salary, then list of Salary will be listed...

Hi, I have a database on sheet 1 and i want to copy data on the basis of city on separate sheet. Sheet 1 <tbody> CITY NAME ID NEW DELHI RAKESH C101 PATNA SUMIT D102 NEW DELHI RAJU F103 BANGLORE A.ANNA R104 PATNA SUMAN E105 BANGLORE D.RAMAN R106 </tbody> I want to...

Please help with a Match issue. I have two ranges I need to search for a match then pull data associated with the matched location. Here's a simple example of column setup: A- Name B- City C- Score D- Name E- City F- Score I need to look down column A and D to find Name and pull Score. Then...

I have a table with 3 columns, A= Name, B= City, C=Item. This table may have thousands of rows of data. I then have a second table that list each City and each Item for that city. In column H I need to return the Name that appears most often for that combination of City and Item. I this example...

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

<tbody> 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 is given in Table I </tbody> <tbody> Table...

Hello, everyone, I ask for your cooperation because I have difficulty with one part in making a particular macro. I've found many ways to copy multiple worksheets into a new workbook, but then I have to leave specific data in it. Explanation: I have a master workbook with 86 sheets, 28 of them...

I've been searching google and through trial/error trying to figure out how to accomplish the following and not having much luck. A little bit of background on the file I'm trying to create. Each worksheet of the workbook will be used to collect data about specific individuals in a particular...