europe

  1. P

    Multiple Reporting

    Hi - looking for help with regards to multiple reporting. I have 4 Elements Business Areas - up to 100 Products - up to 20 UK or Europe New or Used Product I am trying to report the volume of all products within each area and whether they are New or Used in UK and Europe This would be...
  2. M

    Filtering Challenge

    <tbody> Business Unit Cluster Country Category Subcategory Segment Market Sector SubSector Brand Productnumber Sales Turnover Cost Profit Turnover per piece Cost per piece Profit per piece Europe UK & Ireland Ireland Fastfood & Drinks Refreshments Burgers Events Festivals Outdoor OYT 123...
  3. A

    Cleaning all text between two characters or extracting specific data from a cell

    Hi, I have incident log in a cell and wanted to extract the date/time and user details from the cell and remove other details. Example : I have incident log as " 30/03/19 18:00:05 Europe/ (shuklla) ...
  4. B

    Adding second serie on Bing Map in Excel2016

    I'm trying to display a second serie on the Bing worldmap, it shows series 1 (FSE) but not series 2(ASP) altough I did selected the data? Data table looks like this: <tbody> Region Country FSE ASP Europe Belgium 6 1 Europe France 26 4 Middle East UAE 8 2 Africa Morocco 6 1 </tbody>
  5. R

    Highlighting Specific Cells In Another Table

    So I have a spreadsheet and I am trying to highlight the team name in the 2nd table, based on the next blank cell in the first table. What I am hoping for is that after i put in the score in table 1, it will change the highlight in table 2 to the next matchup. This will allow me to better see...
  6. M

    CountIF Unique Terms + Condition

    Hi - Hoping you can help with the following excel formula challenge: I am trying to do a count if of unique names given one criteria The sample data set is below I am trying to come up with a formula that shows for Europe I have 1 unique name; For Asia I would get a unique count of 2 unique...
  7. T

    SUMIF in Power BI

    How to use =SUMIFS for below table in power bi. =SUMIFS(PRIOR MONTHS,REGION,SALES REGION,UI,PID) <tbody style="box-sizing: inherit;"> Prior Months Region Sale Region UI PID Europe Europe ABC ABC 12 Europe Europe XYZ XYZ 12 Europe Europe OPQ OPQ 2.5 Americas...
  8. P

    Stacked Bar Chart

    Hi Looking to create a stacked chart from the following data, with 5 columns for each region (Latam, Asia etc), which each column showing the contribution from each country. Thanks in advance! <colgroup><col><col><col><col></colgroup><tbody> COUNTRY REGION WGTD SPRD CN CHINA ASIA...
  9. J

    VBA Copy range

    In a current workbook. Want to copy a range to another workbook. Error message: Compile error: .Copy Method or member not found? Sub Select_current_region() Range("A1:I132").Select Selection.Copy Destination:=Workbooks("AB Europe Gmbh - BS Rec Sep.xlsm").Worksheets("TB Sep").Range("A1")...
  10. J

    Lookup from a cell any word in a column and return value next to it...

    Hi Everyone, Table1: <tbody> UK Europe France Europe Germany Europe India Asia Christmas Island Asia South Africa Africa </tbody> I have a question please: <tbody> 543 Germany 09235035Germany333 South Africa fjjdogjg sogj osidj UK 034jhb 4ff 345Christmas Island3 k3k...
  11. J

    Combining multiple sheets with mostly similar columns - VBA

    I am really struggling trying to combine multiple sheets into one. The first ~80 or so columns are always the same, but then there can be some variation in the next. Sheet 1: <tbody> ID Name US Africa Asia Europe 32 Bob 34 32 29 10 39 John 91 20 18 47 </tbody> Sheet 2: <tbody> ID Name...
  12. R

    This might be a stupid question.....

    ...but after days of dedicated Googling that have not yielded results, I need help. In a nutshell, I use huge datasets to run a dashboard and to make it work I need to relabel each line of data to tell me what Division it applies to, and what Function. Bearing in mind these are workforce...
  13. B

    3D Map 2016 Excel

    Zip Codes, the New England section of the United States where the zips are truncated in excel like 01001 or 01002 end up in Europe after I load them into the map. I thought it was because the first zero was truncated, so I formatted cells with 0####. However this still does not work, and the...
  14. P

    Multiple nested if statements with the =IF(ISTEXT(SEARCH

    So I just started cutting my teeth on some of the more complicated parts of Excel. I want to output one of a variety of text strings in a given cell based on a variety of text strings in a column to the the left. Some sort of fuzzy match would be excellent as well. I'm not using VBA either...
  15. K

    How to merge data together and combine data?

    <colgroup><col width="64" style="width: 48pt;"> <col width="316" style="width: 237pt; mso-width-source: userset; mso-width-alt: 11556;"> <col width="64" style="width: 48pt;" span="5"> <col width="127" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4644;"> <col width="246"...
  16. Nelson78

    Find the last specific value in a column

    Good morning. In my work the column D is populated by a word, for example "Europe", a lot of times. I need a vba code in order to find - and select - the last cell of that column populated by "Europe". My attempt is just a manual operation recorded by the macro recorder, now I need a help for...
  17. G

    Showing sub items for only certain items in a Power BI table

    Hi all, I have data for countries and I want to group the European ones and to show a subtotal. So my table rows would be something like. Europe UK France Germany Italy US Japan China I easily created a Europe group through right clicking in the field list. However, when I put...

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