united

In the below example I have a list of open invoices sorted in alphabetic order, Column C, and customer number, Column A. I want to have the color of Column: C - Rows: 4,5,6 and 7 changed to RED because M4 contains the letters NR. My spread sheet has 6,000 to 20,000 rows and column A and C are...

Hi all, I am trying to create a Map Chart with English Regions and/or local authorities. I think the latter is impossible, but the former two should be possible. I think my issue might be something to do with my labelling of the data? The regions of England are...

Hi Guys, I would like to change excel function to VBA Code. Here is the excel function,=IF(AND(ISERROR(FIND(" ",E3))),IF(LEN(E3)<3,E3&"?"&$F$1&E3&"??",E3&"*"),IF(LEN(E3)>3,SUBSTITUTE(E3," ","")&"*"&$F$1&$E$1&E3&$E$1,SUBSTITUTE(E3," ","")&"?"&$F$1&SUBSTITUTE(E3," ","")&"??"&$F$1&$E$1&E3&$E$1))...

Hi In column "L" I have a list of cities/countries: Toronto, Ont., Canada Montreal, Que., Canada Toronto, Ont., Canada Manchester, England, United Kingdom New York City, New York, United States Frankfurt, Germany Abuja, Nigeria Frankfurt, Germany Manchester, England, United Kingdom Doha, Qatar...

Hello Community! I come to you again in my hour of need. I have a task to update roughly 30,000 medical consent forms in Excel. I have been putting together scripts to automate the process, but I am stuck. I need a script that I can give it a couple of words to start a search and then a...

<tbody> A B C D 1 United Red 2 United 3 City Blue 4 United 5 City 6 Spurs White 7 Spurs </tbody> Hiya How do I get Col B to cells to populate with "Red" if the cell in Col A is 'United'? Likewise City in B5 should populate as "Blue"; and...

<tbody> A B C D E F 1 Team Name Rating Man of Match 2 United Smith 10 Yes 3 City Brown 9 Yes 4 United Robinson 10 Yes 5 United Smith 10 Yes 6 City Brown 8 No 7 United Smith 9 yes </tbody> Excel folk Once again I turn to...

Hello, I'm looking to inquire about how to return a country's cost, based on a given weight. The issue is that the weights I'm looking up against have predesignated weight breaks, the given weights ('B' below) may fall between the range. I'm ultimately looking to return the rounded up value...

Hello Recently I got some help on here putting a frequency function into a worksheet. I've been using & adapting this as required. This is typical of the formula I've been using. {=SUM(--(FREQUENCY(IF($V$4:$V$498="UNITED 1",MATCH($AD$4:$AD$498,Nov2018Daily!$AD$4:$AD$498,0))...

Here is the data I am working with... <tbody> MultiEmployees English (United States)-> Polish (Poland) Afaf Steiert (Afaf Translations) Chinese (China)-> English (United States) [SN0017] Future Trans English (United States)-> Slovene (Slovenia) [SN0017] ES Localization & Translation...

I have a table with two columns in Excel: <tbody> A B 1 United Kingdom London 2 United States of America Washington DC 3 France Paris 4 Spain Madrid 5 Japan Tokyo </tbody> Column A is populated by an external data connection from a CSV file. Column B is data that I then manually...

Hi, I have thousands of records of longitude/latitude pairs in excel and would like to compare them against shapefiles to identify what area (United Kingdom local authorities) they sit in. This is where the United Kingdom area perimiters are defined...

Hello, I have a pivot table that I am struggling with. The back story is that I use Microsoft Dynamics GP and Excel Report Builder. The excel report is a refresh able report. This report is used to capture our EFT and Check information so we can submit it to our bank (so they can send out our...

Hi, I have a sheet with a table with two columns: the first column says countries and the second column says fruits. Countries Fruits South Korea China United States Russia Australia Singapore If I enter values on some of the fruits for some countries and leave the...

Hi Guys, im working on a database for my works units that we send to events, ive made a formula that works perfectly when looking at a certain location, where is the locations are represented by a number (ie. 1 is Australia 2 is United States and so forth), but id like to make an option to see...

<tbody> Company Name<strike></strike> Group ID<strike></strike> <strike></strike>PM Account No<strike></strike> <strike></strike>Value<strike></strike> <strike></strike> <colgroup><col></colgroup><tbody> Desired Result </tbody> <strike></strike> <strike></strike> ELUMATEC USA...

Hi, I am writing a VBA code to automatically clean up some excel reports I run on a regular basis and I have a situation where I am stuck. Column J of my data contains Country Names and column K of my data has State Names. Here's what I need: If the values in column J are not equal to either...

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