west

Hi all, Got a quick question whether its possible to include totals in my database according to the drop-down I select. I currently have a database that have 4 different variables and another tab that brings me a P&L view using sumifs according to the chosen variables. There's a drop-down...

Hello, I have the following look-up formula: =IFERROR((VLOOKUP(AG2,Sheet2!$L$2:$M$617,2,0)),"N/A") I would like to add a condition to this formula that says: IF Column BD = Hello, then return a value of "MK" regardless of the look-up value. Essentially, this logic should override the value...

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

Dear All, I do have the sample data set across A1:C6. I would like to concatenate as follows:- <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Region Store Result East a East b East c a-b-c West d West e d-e...

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

Would you please help me to add numbers with certain specific/description. I just wanted to add all numbers which EAST numbers and West numbers separately as the desired result shown below <tbody> Region Amount North-West 150 South-East 200 South-West 100 North-East 150...

Hi All, I don't know if this has been answered as I don't know how to word the question. I want to put some code together which will do the following: Put the code in Cell A1 vlookup(B1,namedrange,2,0) I can do the above, however, I want to fix the namedrange within the code as it will...

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

Hi, I have the following as an example of the data that I am working with. I am trying to get a formula that allows me to select the year, week number, and shop, and also allow me to dynamically select the sales (Beer or Wine or Spirits) and then sum them over a period that I define e.g. I...

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

Hello, I receive address files from clients that are rarely formatted properly and usually have all their data pasted in 1 column. (See example below) I've made a macro that adds "|" at the end of Street, Ave, Road, etc and then splits into different columns but I can't figure out how to split...

I have looked at a dozen pages and I cannot understand why this is not working. The INDIRECT range on the left should be exactly the same as the range on the right but I am getting #REF !. =SUMIF(INDIRECT("'" & A11 & "'!" & AM2:AM5000), ">0", 'West Creek'!AM2:AM5000) The value in Cell A11 is...

<tbody> A B C D Active Groups # Group # Region 000002 007895 West 008975 000002 West </tbody> Hello, I can't seem to find a workable vba solution for this problem:I want to count the number of active groups per region. i.e, West Active Group Count =1 (Group00002 is the...

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

Hi Mr. Excel, I've created a pivot table using the data from the table below. In the pivot table, I've added the percentage columns that included for all regions and grand total. However, I want to see % column for grand total only. Is there any way I can remove the % columns for the regions...

Hi folks, I'm trying to figure out a formula which will do a lookup of a region to find cities to sum sales in an associated table. I can manually do this by hard coding SUMIFS statements. However this is not scalable and will be too difficult to maintain before long. Any ideas on how I might...

I'm looking at calculating how many days a ticket has been open and the average days all the tickets have been open for that month and group. I have a date table that is not connected a ticket table <tbody> Ticket Group Created CloseDate Broken Screen West 8/24/2017 4/26/2018 Broken Mouse...

If I put "East" Under the shops in my Output sheet, then all the rows which contains "East' in the Reference sheet should get pulled up. The problem is that Shops column contains input like this "East, West and North", "East and South". It would have been easier for me to extract data through...

Trying to extract number value in string using VBA. The range dynamic. Thanks for any help... <tbody> Before After WEST 1 (LEFT) 1 WEST 1 W 1 WEST 2 2 SOUTH 1 (RIGHT) 1 </tbody>