Search results

How about another iteration - what if we calculate it for Meat only (see Part 2), the red tab

It worked - thank you very much!!! Forgot all about good ol' SUMPRODUCT :)

Hello, Please see the attached example. The yellow part of the data section shows percentage allocation of each product by region. The green section shows the allocation of the same product by distribution channel. Now I need to "marry" the two and get the sum by region by channel (at this...

Yes, thank you very much - greatly appreciated. Very creative and easy on the eye :)

Thanks for your input, but I am looking for adjacent stacked columns, 2 per region, split between 2 different product types

Forgot to mention - I am not supposed to use macros or VB script as it will be on the shared drive

Hello, Here is the simplified version of a chart that I have to create in Excel. There is a sales chart that shows breakdown for 2020 by region, stacked by product type. Now I need to add a column for 2019 for each region, broken down in the same fashion (by product). I highlighted the columns...

In my original post I forgot to mention that the order in which locations appear is not static. My example includes 4 sites. The real-life situation includes over 300 rows that should be sorted, filtered, and manipulated the way the users see fit. Thanks!

Thanks! Unfortunately, I don't have this option at work. I also need to have the ability to shuffle the order of regions so it is not contingent on how it is sorted on the data tab, so I can't assume that the order will remain the same.

Sorry... it worked this time... thank you ! Thanks, it did work. I am using Office 365. I was just used to { } format. Thanks again for all your help!

Thank you! I am not clear about <Ctrl>+<Shift>+<Enter>... I copied across, and B2 is the only cell with a result. Could you please clarify? I haven't dealt with arrays in a while. Thanks again

Hello, Need some help organizing data (please see attached). The data tab has detailed data by product by region. The list is basically a classification database that translates each product into a category. I need to populate the summary tab to calculate how much profit each region generated...

It worked - thank you!!!! :)

Greetings, I am trying to create a unified formula that can be copied without modifications to multiple tabs (this example is obviously simplified). On the attached spreadsheet, I populated the tab labeled "North" with the shell for the desired outcome. I want to do the SUMIFS by using the...

Thanks!

Greetings! I am trying to eliminate the days when the total sales were under $100. For the sake of this example I am eliminating other data from this file. Do I have to insert add column D that sums up sales from apples and oranges and use the logic COUNTIF($D:$D,">=100), or is there a fancy way...

Perfect - thank you!

Vletm, thanks for your response. It is close, only I would like not to have the ord/del labels and want to see the columns that represent the same month adjacent to each other. If no orders got fulfilled, it is OK. Thanks again!

I have to show the number of placed orders and the number of fulfilled (delivered) orders by month. How do I do that without having multiple legend entries (I can get there with Red-Delivered, Red-Closed, but need to have just Red, Orange, Yellow, Blue, Green). The goal is to have January Placed...

Thank you!!!!

Hello, I have a list of accounts listed in the left-most column on the Data tab (please see the attached workbook) and the associated amounts by month. I need to create a data load on the Result tab that would list all the amounts associated with each month. I cannot use VB project or macros...

THANKS A LOT!!!

Here is the file (simplified). I have a series of alpha-numeric strings in column A. Column B counts the number of occurrences of each string in column A. My task is to use a formula that would be an equivalent of removing duplicates, either in column C or in a pivot table. Thanks!

Thanks, Narayan. I will modify the data and post it later on today.

Unfortunately, none of the formulas are applicable. I need to avoid using macros or VB projects. I need an Excel function that can be used without activating Add-Ins.