south

  1. P

    If Statement

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

    Excel Formulas to generate random values adding upto 100

    Hi Experts, Need your help in this. My boss wants me to create values for a group of materials bifurcated on basis of pack x Channel, now the values for a pack/channel combination should sum up to 100. <tbody> Unit Brand Channel Pack Value% EAST Product 1 Insti Medium EAST Product 1...
  3. E

    Longitude Latitude Question

    Hi, I am trying to find a formula that would determine the distance (in feet) that these two coordinates varied from. In this case, to be expressed as "X" (amount of feet south) and "X" (amount of feet west) or original point. Then total distance as the crow flies. <tbody>...
  4. L

    Power Query - Pivot with multiple values

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

    Vlookup - multiple columns

    Hi, Every month a sales report is pulled showing all activity for each sales person from the beginning of the year. This tab is the total sales overview. It is sorted alphabetical per sales person. Then a tab is created per sales person. Each of these sales person tabs needs to reflect all...
  6. O

    Vlookup yet again

    Hi, I have a spreadsheet with 5000 rows and 15. The 1st Column either has a Y or N in it and the 12 column either has a 'South' or "West" in it. What I would like to do o a different sheet is display only the rows that have a Y in column 1 and South in column 12. I would also like to only...
  7. M

    Create Worksheets based on a table

    I have a table that looks like this: <tbody> Company Invoice Amount 1 Amount 2 Amount 3 Amount 4 Amount 5 Page Last Page John Q Company 3063615 $ 101 $ 200 $ 25 $ 25 $ 25 1 1 Peter North Company 3063616 $ 999 $ 877 $...
  8. B

    sum but ignore existing concatenated criteria

    I have client in column A. Coverage in column B. Location in column C and Income in column D. I'm hoping someone can help with the formula for column E. In column E, I want to sum everything for Client A as long as the combination of Client&Coverage&Location doesn't already exist. If that...
  9. L

    dynamic assigning cell to another cell

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

    Segregate Data based on Date along with required fields

    I am looking for some help in one formula to get the desired output...I have data table something like below...which includes Name, Date, Amt, Type and Place... I have only Type1, Type2 and South, North...these will not change. <colgroup><col span="2"><col><col><col></colgroup><tbody> Name...
  11. A

    How to achieve this in Excel

    <colgroup><col><col><col><col span="2"><col><col span="4"></colgroup><tbody> Site Name Transaction_End Sales_Mix_Ind Payment_Method Payment_method_Std Fuel or CR Fuel CR ES Card Sedgemoor South 20/05/2018 00:09 F Euroshell CRT 2 ES Sedgemoor South 20/05/2018 00:09 C British Pounds...
  12. M

    compare and color code

    I just want to compare the number in report A column G to numbers in report B row 7 and use a color code when the numbers do not match. What is the best function to do this without opening the tow reports at the same time all the times. Thank you for your help and time! Report A <tbody>...
  13. M

    Combine adding numbers and color formatting

    I just want to add a total amount for region East, Branch 1 and product 1 only for the months highlighted in blues. The result is shown in a different workbook (A), but the data/ information is saved in a different workbook (B). I want the result to be shown in workbook A whether workbook B is...
  14. 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...
  15. R

    Counting Payments Based on Rows and Columns

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

    Excel Pivot Table - Show % only for the Grand Total column

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

    SUMIFS, VLOOKUP Formula

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

    Extract Right VBA

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

    To automate Getpivotdata formula from region to region AND month to month

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

    Generating a List based on enterie Totals

    After a solution to a problem I'm having with generating a list that is populated with entries that are defined from a separate table. So I need to generate a list that looks like this <tbody> North East South South South South South West West From a table that is...

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