countries

Hello! I'm working with two worksheets. One worksheet called "Holidays" which has a table where the rows are holidays dates from multiple countries and in the columns the name of the countries. If on a date it's a holiday in one or more countries than below that country it appears the word...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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