north

Hi All, Does anyone know (in power query) how to Pivot data where 2 fields would appear in the value area eg: Columns would effectively be made up of Period and the 2 amount fields. Source Data: Account.Branch…….Location……….Period.............Amt1………........Amt2...

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 trying to build a pivot table that will sum up the total number of Transfer items in the Wa Cd column and total the # of actual reported hours for the entire Job Number. If I filter on the transfer item it will only total the number of transfers. Is this possible in a pivot table? Below is...

Hi All, I'm working on trying to produce some stats for a football league I help run. As the results come in I just put a W or a L against the team name to show if they won or lost. The data is in columns F2:G1255. An example is show below. I want to create a formula that shows the most...

I'm having an issue with a pivot table giving me "#DIV/0!" because it is taking the average of a number and a blank cell. How can I have the pivot table take the average of desired values but ignore the blank cells? <tbody> Team Program Completion NorthA North NorthB North 40% NorthC...

Hi I have table like below. Cell B2 = B9. I want store location to be shown in B2 after I filter the main table. So if I filter South, then I want B2= South, if I filter North, then I want B2= North Right now, it does not work, it always shows "East". Any idea how I can solve this? Thank you so...

Hi I have a table like the one below. I inserted a table (Insert-->Table). Now I understand (thanks for you help). This table have these ranges Table1[name] Table1[store] Table1[item] Table1[price] What is the benefit of using these ranges rather than I create my own ranges for example I...

Hi I have a table like the one below. I sorted "Store" column. I want to find the subtotal of east store or subtotal of north store or north store etc. using subtotal() function. I know after sorting, I can go to Data tab-->subtotal, that is an option another option maybe I can use SumIf()...

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 just want to do a color formatting for regional sales in column B (from B2 to B8) using the value in cell A1 and add the total number of the same color/Region in E column (E2 to E5). Desired Result <tbody> A1 B1 D1 E1...

I am trying to count the number of payments (non-zero) made in a fiscal year based on the property. I can do a Countif for each column but there can be a large number of columns (properties) so I would like to be able to create a formula using the whole array that can reference the property and...

<colgroup><col width="62" style="width: 47pt;" span="6"> <tbody> Sheet 1 A B C D E 1 North 8 10.00 A001 9 2 North 9 0.00 A001 3 North 7 30.00 A002 4 West 9 50.00 A006 5 West 8...

Is it possible to use a formula to return the result as per below: <colgroup><col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="112" style="width: 84pt...

Hello i was wondering if i could get some help with a count if/vlookup forumula. Need to look at each direction, first looking at "north" direction in the month of "JAN" Then need to look at the "NUMBERS" sheet and see how many times does that number matches the one that is in the DATA Column...

Daer Boss, PFB the table of excell . and please share the result. <tbody> Daily Sales 1-Jul-17 2-Jul-17 3-Jul-17 4-Jul-17 5-Jul-17 6-Jul-17 7-Jul-17 8-Jul-17 9-Jul-17 10-Jul-17 11-Jul-17 12-Jul-17 13-Jul-17 14-Jul-17 15-Jul-17 16-Jul-17 17-Jul-17 18-Jul-17 19-Jul-17 20-Jul-17 21-Jul-17...

Daer Boss, PFB the table of excell . and please share the result. <colgroup><col span="2"><col span="3"><col><col span="2"><col><col span="4"><col span="324"></colgroup><tbody> Daily Sales 1-Jul-17 2-Jul-17 3-Jul-17 4-Jul-17 5-Jul-17 6-Jul-17 7-Jul-17 8-Jul-17 9-Jul-17 10-Jul-17 11-Jul-17...

Good morning , friend How are you ? Like to learn (If possible), Excel automatically change from North to South for Jan, then, change automatically from Jan to Feb, and gives amounts for both North & South for Feb , then, change...

Can I use a pivot table to get the result shown below? How can I get the row labels for each sales agent and have add a blank row after each sales agent. <colgroup><col><col span="12"></colgroup><tbody> Sales person Name 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Product...

Hi all I have a reporting hierarchy which is laid out like below: <tbody> North East Sunderland A North East Sunderland B North East Newcastle C North East Newcastle D North West Preston E North West Preston F </tbody> I need a macro to convert it to the below: A B Sunderland...

I'm trying to create a sumifs formula to determine the sales of a state for a certain sku in a timeframe. This is just a subset of the source data. I'll be looking for a few states, but Iowa to start. This info will be populated in another cell. Iowa for sku 2330993 and for this week 201711...