Search results

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.