countries

  1. 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...
  2. O

    Extract only the Titles that not empty

    Hello friends, In the example I have attached, I have a list of countries where some states have data in the same column and some do not. In the table below I would like to see only a list of countries that have data. Hello friends, In the example I have attached, I have a list of countries...
  3. T

    Data validation in 2 columns

    https://chandoo.org/forum/threads/data-validation-for-2-columns.42439/HI, Looking for solution to one problem. Problem is -we have number of countries in different regions like Europe,Africa etc. I have data validation in col A and Col B...when I choose any region in col A it is also showing...
  4. E

    Vlookup in a string

    I am trying to cleanse a user input list of countries of residence. in some cases the country is hidden in a string of other words like this "kobeshi hyogo japan" I want to lookup from a list of defined countries I have using =VLOOKUP(A4&"*",'country list'!$A$1:$A$165,2,0) but it returns #N/A...
  5. R

    return column header for each value occurrence in a table

    Hello, I have a table countries and jobs in that country. I am looking to select the job and get all the countries that job is in. Example: select Janitor and the output will show USA,China and Canada <tbody> USA Spain China Canada Mexico Janitor Payroll Janitor HR Manager Operator...
  6. T

    VBA Arrays for concatenate?

    Hi all, I have long a list of entities with a unique code, and the countries where they are represented. I want to discard all "GB" and then list all counties per entity in one row. See example. I tried out with arrays but couldn't figure it out. INPUT Desired Output ISIN...
  7. A

    Checking multiple cells to see if they contain any of a list of choices

    Good morning guys... I have been racking my (less-than-ample) brain on this one for a couple of days... please help... If i have a questionnaire which contains something like "What countries do you do business with?" and it yields a single cell with all their answers delimited by a comma, is...
  8. O

    Count Text from Multi-Select Drop-Down List

    I have a column for each record where a multi-select drop-down list displays various countries. I would like to count the number of selections (in this case countries) that each row has selected. Example: Row 2 has the United States, Canada, Mexico, and South Africa selected in B2 and Row 3...
  9. H

    VBA Filter Issue

    Hi I'm trying to filter using the below: Sub Del_Rows() Dim Countries As String Set wk = ThisWorkbook Set ABC = wk.Sheets("123") Set Countries = Sheet1.Range????? Application.ScreenUpdating = False With ABC.UsedRange .AutoFilter Field:=3, Criteria1:=Countries .AutoFilter...
  10. J

    Fastest way to determine simply if a part is on more than one worksheet

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

    Excel VBA to Copy non-blank cell values to another sheet

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

    Access 2016, many-to-many relationships and subforms

    This is a bit frustrating: I know that this is something I myself have managed to do in the past, with the help of this forum - but it's been half a dozen years since I worked with Access, so I can't remember how best to solve this. I'm currently putting together a database for work that will...
  13. A

    A2 = Sheet2!A2

    Hi I'm using the following formula alot in a workbook: A2 = UK!A2 A3 = USA!A3 etc, etc It's not the best as i have to ether physically type it, or go to the relevant sheet and link it. I have a list on countries which correspond to the tab names so can I use something like the following...
  14. C

    Using "If then else" in column with validated options

    Can anyone point me to an example of using "if then else" in a column with drop-down options? I have a drop-down list of countries (Angola, ..., Zambia) and in the same list a further option - Intercountry. I.e. all in a single column. I would like the validation to permit the user to select...
  15. M

    Power Pivot - Show top 3 values ang group rest.

    Hi, Im looking for the way to show in pivot table top 3 max values (i.e. top 3 countries with biggest revenue) and group other countries in one cell. This thing will be used in monthly reports, so it will be good to make it atomatic. Is it possiable? I will be very grateful for all your help...
  16. J

    World Map by country - custom color code

    Hello, I'm trying to find a way to show the world map with all countries. I want to color all countries based on criteria will be 4 colors. Example of country colors - cleared (blue) - removed (red) - review (yellow) - approved (green) What's the best way to do this? I'm not opposed to...
  17. T

    Group sum

    Hello, I have a table like below: <tbody> </tbody> <tbody> Countries Time spent SA 300 TR 400 CI 800 SA 500 IN 755 IN 900 BR 1800 FR 500 UK 752 FR 400 SA 800 US EN 733 UK 900 FR 600 </tbody> I need to display the sum of the hours grouped by countries. For...
  18. T

    pivot table filter based on range

    Hi everyone, i would like to kindly ask you for your help pls. how to set up filter in pivot table based on cell values without changing raw data? lets say that in column A i have following values Countries: Romania Russia Denmark and these countries should be automatically selected in...
  19. P

    Looping through Object

    Fellow sufferers I am doing something´like this: inhabitants_in.Add "Norway", CreateObject("Scripting.Dictionary") inhabitants_in("Norway").Add "Oslo", 200000 How can I best, later, do something like, to find all the countries in the root: For each country in inhabitants_in...
  20. K

    Slicer grouping in Power Pivot setting

    Hey guys, I have a multiple tables linked together through an auxiliary table since Power Pivot doesn't allow "many-to-many" relationship. So, table A have this "Destination" column where it lists out countries in its field. Table B is this auxiliary table. Table C also have "Destination"...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top