south

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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>

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

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