region

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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