country

On my workbook I have 2 sheet Sheet1 “Customer Records” Sheet2 “Treaty Discount” The user fills in a web form with their details and state that they wish to apply for a discount under treaty X for their country and X percentage amount that treaty allows. I need a way of...

Hi, I have a list of data and need it converted to one row per country: Country DIAL CODE AFGHANISTAN 93 AFGHANISTAN MOB AFGHAN TEL 9374 AFGHANISTAN MOB AFGHAN TEL 9375 AFGHANISTAN MOB AWCC 9370 AFGHANISTAN MOB AWCC 9371 AFGHANISTAN MOB MTN 9376 AFGHANISTAN MOB MTN 9377 AFGHANISTAN MOB MTN...

<tbody> Hello, I need help identifying a formula that will locate the "country of origin" attribute in a data set (Example below) and extract it. All of the html exists in a single cell & I want all of it to remain there, except for the country of origin portion. However, each row might have a...

Hi and Thanks in advance I have 3 column: Country Total Check in Country I may have 20/800 Different values Total = Total and in Check I would like to know for the Same Country If I have more than 1 different value So if Spain has Total = 30 i every single Row I do not have to Check anything...

I have 400,000 Unique parts, from all countries on 1 tab. I have 12 other tabs, one for each country with a unique list of parts for that country. Some parts are in more than one country. maybe one other country, maybe 5. All of my tabs for each country as a named range for its unique parts...

What steps should I take to group these pivot tables together ? An Excel workbook (ERPSim Logistics Data) is attached to this midterm that contains data from the ERPSim Logistics Game with two worksheets: (a) ERPSim – Purchase Order and (b) ERPSim – Sales. For each of these, build a...

An Excel workbook (ERPSim Logistics Data) is attached tothis midterm that contains data from the ERPSim Logistics Game with twoworksheets: (a) ERPSim – Purchase Order and (b) ERPSim – Sales. For each of these, build a hypercube (pivottable) that summarizes and compares data from two countries...

Good morning all, I have a complete brain freeze over my problem outlined below and would very much appreciate any help as I will have several spreadsheets I will need to do something very similar with. I am not sure how to write an if statement to look if a cells contains certain text. In...

Hello Everyone Im wondering if anyone knows of a faster alternative to this Array formula- {=INDEX('(System) SC Country 1'!$C$5:$C$5000,MATCH(0,IF(('(System) SC Country 1'!$D$5:$D$5000="Incomplete")*('(System) SC Country 1'!$G$5:$G$5000="Routine")*('(System) SC Country...

Hi, I want to have a formula that looks through a range of cells, and if a country is listed ( i.e United States) in a cell, then it will enter the 2 letter code in another cell (i.e US). This would apply for approximately 70 countries.

<tbody> I have an Excel sheet that calculates the positions of each country in a Group after placing the scores of each match for the 2018 World Soccer Cup in Russia. I have national flags corresponding to each country shown on the top of the 1st rectangle in the example and on column AC. The...

Dear MrExcel Team, I created the following table in the same worksheet as the original table (with the source data): <tbody> Region Country Event 1 Formulatext of Event1 LaCan COLOMBIA 3 =VLOOKUP(A6,A6:B26,2,0) EU ESTONIA 20 =VLOOKUP(A7,A7:B27,2,0) EU GERMANY 149 =VLOOKUP(A8,A8:B28,2,0)...

Hello, Can somebody help me with this formula I have a excel With a number of columns <tbody> Country Id Title CreationDate </tbody> <colgroup><col><col><col><col></colgroup><tbody> AU 26 F 22/02/2018 DE 190 Et 22/02/2017 DE 242 E 21/02/2018 AU 277 C...

Hi All, I have a model built for Gap Analysis so that our sales team can compare their customers against others and look for opportunities (by category/product/brand/pack size etc...) The comparisons are "vs Same Customer Prior Year", "vs Country", and "vs Global". The "vs Global" measure is...

I am trying to return regions based on list of country names. There are many examples out there, but all I have found involve returning a single text value based on a single country. My data is all grouped together. <tbody> Regions (Desired Result) Country Eastern Europe, Western Europe...

Hello guys, I've been trying to get rid of several Index- Small - If arrays since I'm pulling data of over 100,000 rows and this causes excel to pretty much slowdown and process forever. I've spent over 2 full days trying to figure this out to no avail. This is pretty much advanced excel, so...

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

<tbody> sku stk stk weeks left total week sales uk sales germany sales spain sales uk profit german profit spain profit Total uk prof total german prof total spain prof pen 10000 10 1000 500 500 0 £1 £3 £5 £500 £1500 £0 </tbody> Hey Experts! I'm trying to create a repricing...

I have a simple file of data for Employee, Country and Retention (values = <2 years, 2-5, 5-10 or 10+). Just 3 columns of data. I need to show the % of each Retention group by Country in a Pivot. To do so I've set Retention as a % of column (Country) total. However, as you'd expect when I add...

Hello, I have this pivot table which has 3 attributes in Row section: Category, country, product. What I need to do is that in that same Pivot table at the bottom totals appear which show Grand total per selected Row attribute (in this case Country). Now it only shows overall Grand total. Is it...