east

Hi - looking for help please I have 2 columns which vlookup values within my tab, they are Team Name last month / Team Name this month. I wish to know if these change and report in Column 3. I have about 7 different team names - for this example - North, South, East, West

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

Hi I have a table like below. I highlighted and then Insert-->Tale. I click on a cell outside the table and wrote =sum([revenu]) But I got an error message? Why is that? when I can use Structural table columns? (for example [name], [store], [item] Thank you very much <colgroup><col...

I have a very simple formula that needs to be expanded upon given the number of possible outcomes among the 3 cells that the formulas are looking at. The formulas that need adjusted are in cells C3 and C4. Those formulas must review the data in cells B2, B3 and B4. <tbody> CELL A1 <tbody>...

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've got a data dump from a freight carrier that has columns for ship to /receipt to addresses. The issue I have is that 1 address can be listed multiple ways. For example, 123 East, 123 East St, 123 East Street. I have a list of the proper addresses. How can I go about populating the...

Hi I want to use sumifs() function to find out how many tv John sold for month of March. Is that possible? I can find out how many tv john sold like this =sumifs(E1:E10,C1:C10,"john",D1:D10,"tv") But now I want to find out for month of March. Thank you very much <tbody> date store name item...

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

<tbody> Yr Per Client Amount East 2018 1 CXYZ001 1562.00 East 2018 5 CBLG070 596.55 East 2018 1 CXYZ001-10 8251.99 East 2018 1 CBLG070 9426.33 East 2018 5 CXYZ001-15 7491.76 </tbody> I have 4 worksheets with the same data per region. I need to sum...

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

Dear All, I have one user form details of which are getting capture in excel sheet – Sheet1(Data). Currently with the help of userform code I am just able to put the details like below – i.e. only till its opening stage. <tbody> A B C D E F G 1 Date Region Issue Type...

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

Hi I have two tables (Table1 and Table2) on 2 different tabs (Sheet1 and Sheet2, respectively). Table1 <tbody> Name City Line District James Boston Hard Goods John Los Angeles Soft Goods William Baltimore Soft Goods Harold Miami Hard Goods </tbody> Table2 <tbody> Name City...

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