country

Hi Guys, I've got a lot of cells with useless text and a combination of text + numbers in it that I need and by now I am out of ideas... Sometimes it looks like this: Useless-Text_CD_local random, name (randomname) 2019-10-17T08:20:15 XYZ-COUNTRY-000737 Or like this: Useless-Text_CD_local...

I have a column with full international addresses with no separators (commas or semicolons). I need to search each cell for a country name and put it in the cell next to it. I've tried to use the search function and it works with one country but when I introduce the full country list, I get a...

Hi, I am trying to find on how to find unique value based on two column. Column C must be repeated based on how much unique value available in column D Current formula used in column C is ={IFNA(INDEX($A$1:$A$6,MATCH(0,COUNTIF($C$1:C1,$A$1:$A$6),0)),"")} Current situation...

Hello everyone, I asked a question in the past, but there are some changes here: The table above has data for each country - as you can see - there are a number of missing data. Cell D16 has a Data Validation list of all countries I would like to know that if I select a particular country from...

Hello everyone Suppose if I have a list of countries in column A in a "master" sheet, and all the other sheets are named after each country with more details contained within each sheet. I want to create a macro which will iterate through my list of countries, refer to the sheet of that...

Hi all, My data is like this: In one column (normally D, but could move) I have a 3 digit country code Stored on another sheet, in A:B, I have a digit country code (A) and a 2 digit corresponding code (B) I want part of my macro to lookup the 3 digit code and replace it with the 2 in the...

https://1drv.ms/x/s!AvjBsEPEq12ngTWjooUrD2AsRCFa?e=BpSibC I am trying to do a SUMIFS formula calculating the sales column if the country equals australia, india and china (actual data has more countries) =sum(sumifs(B2:B4,{ If I try to click on the cell to reference it, Excel doesn't let us...

Hi Folks, I have a data set which has role titles in the first column and country names as headers. Each column contains a role cost for each country. I am trying to create a dynamic Data Validation list where it will show only roles where cost is greater than zero for the country selected...

Hello all! I have a project with a client and I would like a slick solution instead of what I usually come up with, which is bulky and slow. I am calculating a shipping price, where i have the zone and weight of the container. This held together with destination country should give me the...

Hi everyone, I am trying to create a report that pulls through data with more that one line when a certain criteria is selected from a list. For example if I select a country I want it to pull through everything that is against that country. I tried a basic lookup but that only pulls through...

hi all, I need an excel formula to count the number of countries per I code that breached a 30% threshold. I am struggling to get this formula done. I used countifs but I only get the number of Keys per I code that breaches the limit. For instance, in the example below, I code B has one country...

Hey Folks, Looking for some help with a bit of logic I'm stuck on. I've done this before, and for the life of me I can't remember how. In Sheet 1, I have two cells that I populate manually with the values I'm looking for. In the case of the example I've provided, I've said I'm looking for...

Hi everyone, I've been racking my brain and many google searches later and have been having a really hard time at this. I would really appreciate some assistance! I've got a file that has a layout like this: <tbody> Product Country 1 Product Country 2 Product Code 1 Product Code 2...

I have a table like this Country, headcount, Month ================== US, 23, May2019 US, 24, Jun2019 UK, 27, May 2019 UK, 27, Jun 2019 Now Excel pivot-table of Country as row and Month as Column, the Q2 column is showing 47 (23+24) for US. So I am thinking I need to use DAX instead... Is...

I have a table like this Country, headcount, Month ================== US, 23, May2019 US, 24, Jun2019 UK, 27, May 2019 UK, 27, Jun 2019 Now pivot-table of Country as row and Month as Column, the Q2 column is showing 47 (23+24) for US. Is there a way the Q2 column be the latest value in the...

I have a spreadsheet full of data in multiple columns. I want to filter on two of the columns on a few criteria and then send the results to other worksheets. So for example, each time I have country a, county b and country c in column A (book titles) as well as author a and Author b In column...

Need VBA help For below data set in sheet "Data" Rollup Country(Column A) Country(Column B) Brand(Column C) Bangladesh Bangladesh Coke Bangladesh Bangladesh Pepsi Other...

I have a large dataset which is a long list of newspaper headlines along with other irrelevant data. What I want to do is when a country is mentioned in a headline, be able to pick it out and dump it in the next cell along So for example: Column A contains a list of all the countries in Europe...

Hi I have a table <colgroup><col><col></colgroup><tbody> Country Client Notification Date BRAZIL 31-May-19 CHILE 20-Aug-19 INDONESIA ISRAEL MALAYSIA 02-Sep-19 NEW ZEALAND PANAMA PERU PHILIPPINES SAUDI ARABIA SOUTH AFRICA TURKEY UAE (DUBAI)...

I have Table A like this Country, Product, Sales ========== US, A, 100 UK, A, 200 US, B, 150 UK,B, 350 In Table A it is like this Country, Product, Rate =============== US, A, 0.9 UK, *, 0.7 I want to join these 2 tables if both Country and Product are same as those in Table B, so that Rate...