country

hi, so the workbook is set up like this, with 4 columns: Column A - country code Column B - country name for that code and then you have the same, but not in the same order Column C - country code Column D - country name i need a formula looks at the country code in C2. If C2 is present in...

Say for example I have a big master table fields: Country, Product, Colour, SalesAmount I have another table storing the filtering criteria: Criteria, Value ========= Country, US Product, Keyboard I wish to have a resulting PQ output table to filter out US Whiteboard for all colours. Any...

Hi, I have a vba code which autofilters an array of countries, and this works fine. The only problems is that when a country is missing from the country column the vba code stops working. I would like some help in the code so that the code can move to the next country of the array filter...

Hello, I need help with 2 formulas please. Unfiltered data is in Sheet1!B2:BB1000 Sheet2!A3 is a drop down list of all country names (Sheet1!AW2:AW1000) First formula needed for Sheet1!A2: If the dropdown country on Sheet2!A3 matches the country in Sheet1!AW2, then put a "1" in Sheet1!A2, if...

Hi I have this formula which works =COUNTIFS(Table1[[Country]:[Country]],"*"&$B184&"*",Table1[[POA / Clients]:[POA / Clients]],"<>*ABC*",Table1[[POA / Clients]:[POA / Clients]],"<>*TBC*") but the last condition that I want to add is searching a number of columns and it returns "VALUE" error...

Hello, I created a macro that uses a counter to create 3 worksheets for each country included in a data tab. The data tab can have a variable number of countries, so the macro counts the number of countries and creates a Cover Sheet, Expense Sheet, and Income Sheet for each country (e.g. the...

Hi I have the below formula I basically want to count if the country in my current table appears within text in my country column in table1 Also since I want to absolute reference the PM, I've use $C$2 as I didn't know how to absolute reference the cell in a table if I just clicked on it. It...

Hi I've inherited a 'badly formatted' document which they need to be able to filter on. Since the document has to remain in it's current state, I can't 'clean' using Get & Transform nor can I convert to a table ...both of which I would love to have done. Is there any way I can use VBA to add...

how would I create a formula to lookup an ID number in column C on a US directory tab or CA directory tab if the country code in column B is either US or CA? Below are the three columns I'm using and I want the file number to look in the specific directory tab based on what country code is used...

Hi, I've hunted around for code for my problem and thought this would work but doesn't. I have a table where I want to filter 'Country Name' = to 'Country' value listed on another sheet. (Then, copy the data from that table to other cells. - which I think I have worked out) Option Explicit...

Hello Everyone, Been banging my head on my desk trying to read a pivot table in one workbook and pull out data depending on a few things. I need to get the total number by Div then the country and display in the comparison table. These are coming from separate pivot tables and data sources...

Is it possible to look up a cells text, then check in a range and if there is a match highlight certain cells/rows https://ibb.co/XyPkXDw Lets say on the link that in the header "Country" is A1. Currently using conditional formatting you can see some of the countries listed are highlighted...

Hi, I have already setup dependent lists for example if in the "Region" drop down in Cell E4 if you select "EMEA" then all EMEA countries will display in the drop down for cell E5. This is what the data looks like <tbody> (Cell D3) Company (Cell E3) ABC (Cell D4) Region (Cell E4) EMEA...

<tbody> Cost value (Local currency) Currency Cost value 500 SGD 3664 EUR </tbody> So I'm stuck in a situation whereby, I'm supposed to convert the cost value (local currency) into cost (in USD). I had made a button to run the VBA Macro to calculate the values and paste back into the...

Hi I have a table on one sheet with a few columns, including COUNTRY, AREA, ROLE and COST On another sheet I have the same columns where people can select the country, area, role from a drop down The sheet with the predetermined area is called called "CTC", some example cells: C7 = USA D7 =...

I hope you can see the image on the link/attached. http://tinypic.com/r/atn28i/9 On the image it shows on the left hand side of the black separator is a blank manifest, the information on this sheet (which will be on worksheet 1) will always be the same. These are different countries I send...

Hi Everyone, I need some urgent help with an issue i am having right now. I have an excel file which has a telephone number of a country in column A and Country code in column B. The telephone number in column A is not in one particular order. Some of them have International code with them but...

Hello all, First post here! I am leaning VBA through trial and error, and I need some guidance. Requirements: Tab A (input): a fix list of countries of 4 (Column A: Spain, UK, USA, Italy) Tab B (input): a variable table of data. Tab C (output): Combine data from Tab A and B. I need to...

I have a spreadsheet of all the major cities in the world along with the country and city population, so 3 columns (City, country, population) and thousands of rows. I want to stick each country onto it's own worksheet, so copy the rows that are for Canada along with the cities and pop columns...

Hello, Column A contains the country codes (with a header row). I need a solution that can make new worksheets based on the country codes. i.e. All rows with country code AA on one worksheet, all rows with country code AB on another worksheet etc. Anyone able to help? Cheers Owen