region

  1. M

    Calculate events for current month in real time based on conditions

    Hi There!! I've been wracking my brain and I can't seem to get it to work. Basically I'm trying to create a tracker that will display how many different events per region are happening in the current month (month when the file is opened by others). Each cell will target a different region and...
  2. G

    PowerPivot create Slicer based off measure calculation

    I need I have a table that has medication on it and a transaction amount. There will be multiple entries due to adjustments and insurance for one medication and one order that went out. I have a measure that basically sums those up and then on the pivot table it will show correctly at the...
  3. B

    How to use SUMIFS to summarize the whole "sum_range", not only the rows where there is a criteria match?

    I have a SUMIFS-formula which here gets its criteria-input from two drop down boxes (in my actual formula 10+ boxes). The table has three columns, the "Sum_range" contains sales and then I have the two Criteria_ranges called "Region" and "SalesResponsible". The values in the drop down boxes are...
  4. A

    Count no. of rows only from Selection area in xla

    I need vba code for geting number of rows in randomly selected reigon only. please note selected region could be randomly selected. only i need the no of rows
  5. R

    Dependent dropdowns + Output with conditions

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

    All Sales Sheet

    Hi, Is it possible to have an updated master sheet to keep track of all sales from other sheets? As sales are added on those sheets it will be also put on this updated master sheet. I have sheets: Region 1, Region 2, and Region 3. These sheets have the same headings except for Column A on...
  7. W

    Cannot Show 3D Map (Region) State Labels?

    Hey there! I'm looking to migrate one of my 2D map charts into the new(ish) 3D Maps. It's a veeeeery standard territory map of the USA, so I'm using the Region type map. Now, here's the odd part: while you can enable "Map Labels" (main toolbar on the Home ribbon), that only adds the Bing maps...
  8. L

    Pulling data from one sheet to another based on various criteria's

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

    filter

    Afternoon Is there a way to filter (smallest to largest) East Region in column D "Sales" without the rows below altered. The Entire row of the East region will be moved accordingly. <tbody> ID Region Code Sales 101 East w 300 102 West s 200 103 North d 100 104 South w 200 105 East s...
  10. J

    perform an average of non blank cells (each cell multiplied by number first)

    I'm trying to calculate an average of a range of cells with each cell in the range first multiplied by 24. I also need to exclude zeros in the calculation. The issue is when I select a different Region in the Region Selector and there are less cities in another Region, I get a Value error...
  11. T

    sumifs with dynamic suming range

    Hi, I'm trying to come up with a dynamic suming range within sumifs formula. I'm trying to sum between today and today +12 with several conditions. How can I get to the below result with a SUMIFS? What I'm struggling with is to come up with a dynamic summing range. Most probably with OFFSET...
  12. S

    Graph question

    Does someone know how to get a chart to look as follows: I have 5 regions and for each region I need two columns: 1 column with revenue target and actual target 2nd column with #days and actual days? Thanks,
  13. T

    On Hand Inventory

    Hi, The objective is to come up with the formula in F4 that give you the number of months in takes to deplete the current inventory (F3) based on your current sales forecast (G2:02) (I put the expected results the formula should obtain) I included the expected results in row 4. Note that the...
  14. T

    Months on Hand Inventory

    Hello All, I'm currently looking for a way to calculate months on hand inventory. Looking around this forum I could not really find a simple way to get rid of my problem. My dataset is as follows; <tbody> Model Region Configuration Measure Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19...
  15. T

    UDF with horizontal and vertical search array and multiple argument

    Hello All, I need your help. I'm working on a file where I need to search horizontally and vertically with multiple conditions. What i did try before coming asking for help here? a) I tried an array formula which worked. However my file contains more than 50,000 rows. This makes the file way...
  16. S

    Data Validation

    I've got a drop down list of customer names in C2. Now I'm thinking of adding a new region field in my file in C1. So if I do a validation of regions in C1, how would I get C2 to show only the list of customers associated to that region? thanks in advance,
  17. D

    Combobox with conditional

    I have this problem here: I have a list of 300 users of a site. Each user has one department (200 departments in total) and one region (AND, BRZ, PER, RDP). Each region has 50 departments. I made a speedometer that shows the % of access on the site by region. I used a combo box + INDEX...
  18. V

    Pivot with 2 sheets

    Hi, Looking for a solution where i can prepare pivot with 2 sheets....i tried by doing it with consolidation of sheets but it doesnt help as it doesnt give you much option of making changes in pivot...like if i want Month or region or mprove name in filter field... Can anyone sugges someting...
  19. M

    Changing Columns/Series in Pivot Tables when Filter is changed

    I am building a model where when regions will be selected via a filter in a slicer but need it to change which field is brought in depending on which region is selected. In other words, I want the slicer to stay so that you can easily select the region, but I need the column headers in the pivot...
  20. S

    VLOOKUP instead of GETPIVOT

    Good morning, I have a rather large data source file with a large pivot table. In another file, I need to pull several pieces of information in order for a macro to work. The problem I am having is that the volume of GETPIVOT formulas I currently have are really bogging everything down. The...

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