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

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

Some videos you may like

This Week's Hot Topics

Top