Search results

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.

Will try - thanks!

Hello, I need to identify the number of unique values in a column without using a macro. I tried using the DISTINCT function but I guess my syntax is incorrect. I have 2 options -either to incorporate it in a data table or, better yet, use it in a pivot table. I cannot use the count of... in...

It should help, thanks.

I have a chart that has 5 different categories of data (e.g., products). The chart is linked to a drop-down list that contains over 50 departments. Some of them have only 1 or 2 products, but the legend is still displayed for all 5. Is there a way to exclude the legend for the rows that have all...

It worked, thank you!!!!

What do you mean? If I do that, it means that every time we are looking at the chart, we have to manually correct the title, and I am trying to find a way around it.

I am trying to link my chart title to a cell that contains the drop-down list (the chart data is tied to that list and changes when a different value is selected). Is there a way to do it? I am using Excel 2007 and need to tie the chart title to the cell $A$1 on the same tab. Any input is...

Narayan, Thanks a lot, it worked perfectly fine. Smallman, The reason is that there are new departments being created, and I am just trying to automate the summary schedule for the future use. Have a great day everyone! Regards, PhillyGirl777

I have to create a mechanism for looking up a value on a particular tab in the file with multiple tabs. I have a summary sheet for multiple departments that lists each department separately. Total expenses are on a particular cell of identically formatted sheets for each department. I know I can...