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