region

  1. L

    Sumproduct help

    =SUMPRODUCT((Data[Column1]=TRUE)*(Data[Counts of Assets in BU])*(Data[Region]=A17)) I have the above formula but for some reason is returning as #VALUE ! Not sure what i did wrong I just need the formula that if column1 is true in the sheet data and Region in sheet Data matches region in A17...
  2. S

    Formula to compare 2 cells with different text

    So I am trying to create a formula that compares to different cells to make sure the area assigned is correct. The problem is how the text is written ... Cell B1 the text reads "Group 55 Region E Area 558" in Cell B2 the text reads "55E8" I need a formula that compares B1 to B2 that shows 55E8...
  3. N

    How do I approach this?

    Hi all, I’m having some difficulties as to how I should approach this issue. I’m confident with VLOOKUP, COUNTIF etc but just don’t know what combination to use to solve this problem. Please see the table in the link below first – https://imgur.com/orj2UIh I want to be able to calculate...
  4. A

    rank.eq with multiple if conditions

    Hi, can anyone provide guidance/examples on rank.eq formula with multiple conditions? I am generating pivot table for Company A filtered by year, and I want to set up a linked table - table 2 (so row values change when my pivot filters change) to display rank.eq for each row value generated in...
  5. S

    Macro to produce e-mails based on values in cell

    Hi all, I have a table that is being filled out with risk orders that I have to e-mail to a customer so they can review it. There can be loads of them, so populating all can take a long time. It has to be dependant on the region (F Column) and the Sold to (E Column), so if there are two orders...
  6. N

    Excel VBA automatically copy entire row to different sheets based on cell value

    Hi ...My excel have multiple sheets as below: 1) Master Data 2) Region A 3) Region B 4) Region C 5) Region D I need to have a VBA coding that will COPY entire row automatically into a respective sheet if the cell value match according to the "REGION". Whenever changes was made in the Master...
  7. K

    VBA Help

    I have tried to adjust a VBA Code that was built for me by Fluff and I thought I was close to getting it to work, but I was mistaken. Sub Kyosti() Dim Cl As Range Dim Ws As Worksheet Dim Ky As Variant Set Ws = Sheets("Data") With CreateObject("scripting.dictionary")...
  8. 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...
  9. JoeMajestee

    Region not correct

    I have a problem I'm not sure if I can explain it well. Here goes: I have a sheet that has continuous data going from row 2 to row 142, row 1 is a header row. I try to sort and it only sorts through row 113 and leaves 114 on unsorted. I use the keyboard shortcut ctrl-down in any column from row...
  10. B

    Can Slicers be dynamically changed?

    Hi, I have 4 slicers which I am using to be able to update multiple pivot tables at once. My question is, is there a function/formula to where I can have the sliders automatically update based on the contents of another cell? Example: I have a sheet containing a list of every restaurant in...
  11. E

    Planning Template

    Hi guys, I am in the process of running a planning cycle and have currently I have managed to design what the template will look like for one area i.e. EMEA. We have numerous areas which have multiple cost centres which are further broken down into accounts at hierarchy levels 1 and 2. I am...
  12. T

    How do you do a RANKX Dax calculation properly??

    I am trying to build out a DAX RANKX formula that will rank Employee ID by Profit. Here is the formula I have today see below... However, this formula messes up when I start to layer in multiple dimensions into rows. Rank - DO Profit by Employee:=IF(ISBLANK([DO...
  13. W

    Formula to find the correct column in a range, and sum the values in that column according to multiple criteria

    I have a report that I receive weekly Column A will always be Region Column B will always be Color Columns C through Z may change, the order may change, a column that had activity the prior week might not exist because their is no activity. The headers in Column C through Z are known to me...
  14. N

    Creating a map chart with England areas only

    Hi all, I am trying to create a Map Chart with English Regions and/or local authorities. I think the latter is impossible, but the former two should be possible. I think my issue might be something to do with my labelling of the data? The regions of England are...
  15. L

    Assign "grading" based on multilpe criteria

    I have a table of data with multiple fields that I need to include to assign a classification, or "grade" to. For example, in my data, I have: department floor set date region average rate of sale I need to assign an "A" to those items who are in the top 30% of rate of sale for each...
  16. M

    Combining Tables

    I am a complete novice at excel, so please forgive me. I am trying to take usage data from my order catalog for two regions and combine them into one table, while keeping the usage totals in discrete columns. The items in the two catalogs are mostly the same, with a few unique items in each...
  17. E

    Double Donut - Need Help!!!

    Good afternoon all, I'm struggling with a double donut chart. I know exactly how I want it to look in my head, but when I create it on Excel, it doesn't look the same! I have a number of products, in a number of regions. For instance: Product A has 10 in Region 1, 10 in Region 2 and 0 in...
  18. 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...
  19. N

    Use a named range/table to lookup names in a countifs formula

    Hi, Hope someone can help. I am trying to create a formula to lookup data in an input sheet and create a summary of key info and gap analysis. the table looks simply as follows: <tbody> <tbody> Input Table REF Region PM Wave Ref 1 Region 1 PM1 Wave 1 Ref 2 Region 1 Wave 1 Ref 3...
  20. B

    Coding in an employee count month by month and per region/department

    Thank you for reading my post. Need to count the number of employees in each month, by category and region. I have linked below a worksheet which hopefully demonstrates the problem best. https://1drv.ms/x/s!AtncZKajpjWngrAPs8RZSmOhLO4VWA

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