Search results

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

No, it's brand new, blank spreadsheet.

Thanks, this is exactly what I did, but nothing showed up in A1 when I ran the macro. Do I have to activate any add-ins? Thanks again!

Hello! I am drawing a complete blank while writing a simple macro. I need to populate a single cell with a text (without actually writing subroutines - just in Excel). For instance, I need to display "sample text" in A1. How do I do it? Thanks!

Great - thank you all!!!

Thanks, SirJB7! Unfortunately, it did not work. Don't know why!

This has been driving me crazy. I know there is something minor and stupid that my eye just cannot catch as I've been staring at it for two long. I am wondering what I have done wrong. =SUMPRODUCT(('[Total Technology Nov.xlsx]Slide 6'!$D$4:$K$4=D$27)*('[Total Technology Nov.xlsx]Slide...

Narayan, Thanks for the input, but your suggestion gives me a Circular formula warning. Luke, Your formula works wonderfully! Thanks a lot! Thank you both for your suggestions. Your help is greatly appreciated.

Hi everyone! I am using Excel 2007. I have two working formulas: =IF($T5="",VLOOKUP($C5,'Plan...

It worked - thanks a lot!!!

Thank you! Here is the formula that is working: =IF($E$3="IP",SUMPRODUCT((Accts=$C14)*('Sheet 1'!V$6:AG$6="Actual")*('Sheet 1'!$V$16:$AG$91)),IF($E$3="LS",SUMPRODUCT((Accts=$C14)*('Sheet 1'!AJ$6:AU$6="Actual")*('Sheet 1'!$AJ$16:$AU$91)))) And when I add another IF statement to account for...

Hello, I am getting an error message when trying to use nested IF functions. There are only 3 possibilities, and I am getting an error message "Too Many Arguments." Is there a character limit in Excel 2007? When I omit one of the "IF"s, the function works properly.