region

I am currently trying to use a formula to identify the top 25 sales man per region in a national list. There are 2 criteria, i.e. target must be met and no red flags which i check using an IF statement. The issue Im having is that i need to limit the results to 25 salesman per region and...

Dear All, I have a data set spread across thousands of row. Below is the sample for the same. I would like to calculate rank based on the Region & Category. The sample data set is spread across A1:D7. <tbody> Region Category Sale Rank A Z 100 3 A Z 140 1 A Z 105 2 B C 170 3 B C 215 2...

Hi everybody, I am working on a dashboard, I have a finished one for a specific region and know I want to replicate that workbook but have the sheet name with the region changed so for example this workbook has: Directory, Region 1, Data. I would like to copy it and have: Directory, Region 2...

I am using the GETPIVOTDATA formula to ruturn data in a PT. How do I reference the PT Name rather then the cell it is located in? Formula I want to use - =GETPIVOTDATA("Total",PT_CRM,"Owner","Person 1","New Type","Type 1","Start Date","Jan 18","Region","Region 1") Instead of -...

Hi There, I was wondering if you could help me out with a Macro i desperately need to easy my work. I have a sheet with 2 drop-down menus and a bunch of tables underneath. 1st dropdown menu represents 1 criteria - example REGION . 2nd dropdown menu represents 2nd criteria - different customers...

Dear MrExcel Team, I created the following table in the same worksheet as the original table (with the source data): <tbody> Region Country Event 1 Formulatext of Event1 LaCan COLOMBIA 3 =VLOOKUP(A6,A6:B26,2,0) EU ESTONIA 20 =VLOOKUP(A7,A7:B27,2,0) EU GERMANY 149 =VLOOKUP(A8,A8:B28,2,0)...

Hello Everyone, I am using sumif function to calculate an amount based on criteria (A2:D2) but whenever there is a blank cell in the Region column the result turns to be "Zero". I am thinking if we can skip the blank cell to get the result. I tried the "*" and "<>" but ends up with too many...

I have a list of two different results that i have to Rank regionally and nationally Where Column F (Region) is the region indicator and Column J (TSRs) is the first result and Column K (ACV) is the second result. For Column J's (TSRs) ranking I will have a great deal of ties. I would like...

I've been working on this for a while. I can relate two combo boxes only. Example of my data: Region District Facilities Tangwa Tangwa_Disctict Tangwa_District_Facilities The problem I believe is that Region on has 4 entries, District has 8...

Hi, I'm trying to plot a scatter chart and need to know how to label each coordinate.. I have the following problem. I have different regions, Middle East, Asia, Europe.. I have a number of cities in each category (upto 20) and the number of cities keep changing based on input.. I have a...

Hi I need help in VBA coding I have region wise different excel worksheets and on each sheet in column D there are some comments and in Column E and F I have values against which there are certain headers in column H Now I want to collect all the comments from column D and values from...

So i have a drop down (B2) that is fed from COL 1 of the Help table Depending on Which is selected my SumIfs either has no criteria (All the whole dataset), Region (Use Col 1 of the data Table and only add matches) Region-District (Use COL 1 & COL 2) Col M = Sales A dynamic Criteria based on...

Hi, i have just started using DAX practically after going through various books & blogs I have a scenario like this I have sales of different products by different region. I need to build a measure in which if I select a particular region lets say region 1 which sells only Product 1, 3, 5, All...

Hi I've been asked to write code which deletes everything from row 9 downwards in a table. The table goes from row 7 (which has the titles) and row 8 has some formulas which should be retained. I'd written this code, which selects a cell in the table, then highlights the region...

Dear All, I have little knowledge in excel, but it made some attempts in summing up all the results in cells into one cells. To be clearer, I have column of writing gender of the people in F and M. Again, the regions of the people are different and they are separated with a row, for example 7...

<tbody> DATE REGION LOWER: 1/14/2016 1/11/2016 WEST UPPER: 1/20/2016 1/12/2016 EAST unique values 1/13/2016 WEST REGION 1/14/2016 NORTH NORTH WEST 1/12/2016 SOUTH NORTH WEST 1/16/2016 NORTH NORTH WEST 1/17/2016 NORTH EAST WEST 1/13/2016 SOUTH WEST WEST...

Hi All, I have three table in my database 1) products with two columns - product, price 2) region with two columns - SalesPerson, Region 3) transactions with five columns - date, SalesPerson, Product, Discount, Units I want region wise net revenue. Calculation for revenue is ...

Hello I'm looking to make this: ='C:\Users\bprest1\Backup\Documents\Inventory\Master Region Stale\2017\[Master Region Stale Report 9-4-17.xlsx]Burris, Michael'!$E1 Use a variable cell reference for the DATE. ='C:\Users\bprest1\Backup\Documents\Inventory\Master Region Stale\2017\[Master...

Dear All I have been helped out by some of the postings on this website already to get an idea about Indirect and how to link this with other functions to work across multiple worksheets with multiple criteria using sumproduct(sumif(indirect...))). These were great, thank you. I am now...

Hi everyone, I have a spreadsheet in which I want to assess a fee if the region is "NORAM". The fee will be 1% of the payments made or 1000, whichever is greater. There is something wrong in my statement because no matter which region I choose the 1,000 fee is being populated as opposed to...