country

  1. M

    Getting specific text or tumber from cell

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

    Unstructured Addresses and Countries

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

    Unique value based on multiple column

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

    Display a list only with the values by country

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

    If a sheet name equals a cell name?

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

    Using VLookup to overwrite existing value used to do the lookup

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

    SUMIFS multiple criteria cannot reference to a cell?

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

    Dynamic Data Validation List Based on Criteria

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

    Search for a value with two criterias

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

    Lookup and retriving more than 1 line

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

    Math + excel formula

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

    IF Two or more values found in range on same row

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

    Find cell value using multiple criteria and a header row that does not always have a value

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

    DAX, how to last value in the period total

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

    Pivot Table how to show latest value in the period instead of sum total

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

    Copy and paste filtered data into another worksheet

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

    Segregate Table data in into columns lists - VBA

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

    Pull keywords (countries) out of a column of headlines

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

    Index Match Error

    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)...
  20. M

    How to modify SQL to make * = all in join query

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top