Search results for query: *

Ah, an elegant solution! Thanks so much, Skip; You are a Great Man! Regards, -Bob in California

Is it possible to use the "OR" function in a Sumproduct logic string. It seems to make sense, but I am having no luck doing this. For instance: =Sumproduct(((state=$A$1)*(OR(unit=$B$1), (dept=$B$1))) Any help would be amazing! Thanks very much, -Bob in California

Thanks very much for the fine dissertation, Dale. I have been teaching Excel workshops in our company for the last couple of years, and your reply has inspired me to include future episodes that will reference DSUM, etc. Have you ever used Captivate software to illustrate an Excel lesson? You...

Dale! You're back! (So am I...) Thanks for the great tip. Another star to you. Best Regards, -Bob in California

Thanks from a Flash newbie, Kenneth. Regards, -Bob in California

Yes, thanks very much, Sawedoff! A star for you! Regards, -Bob in California

Is there a way (preferably easy) to embed a PDF file into an Excel workbook? Any help would be greatly appreciated. Thanks very much, -Bob in California

Skip, Thanks so much for the brilliant solution! The considerable amount of time you spent in replying is greatly appreciated. Another star for a true star. Regards, -Bob in California

I doubt there is a solution, but here is what I would like to do: Excel worksheet with a column of dates and a column of text (5-6 words). I would like to create a chart that has the dates on the x-axis and the "y-axis" values be the text shown in a 45 degree angle. I tried using a...

WOW! Great tip, tf1! Thanks so much. A star for you (highly deserved). Regards, -Bob in California

Good advice, bkrike. Thanks, -Bob in California

Excel guy battling with Word... Having used special formatting (columns, text boxes) in Word, I want to "take a picture" of the Word document and put it into an Outlook email so that it will appear as it was in the original. I know how to do this in Excel, but cannot figure it out with Word...

Cool, Tony! What a marvelous tip! Worth a bunch of stars... Thanks, -Bob in California

Good one, Pixelchik! This is very useful. Another star for you! Regards, -Bob in California

Sorry to sound very ignorant, but I have been searching resources, (including MS "Help"), books, etc., to no avail: Using the Pivot Table Field option with the Advanced screen available, I would like to take a field and show it as a "% of" a "Base field", making it a useful calculated field (In...

Thanks, Uzza! You have directed me to an area I was unaware of! A Star for you. -Bob in California

Thanks for the great reminder re text to columns, Ken. Another star! -Bob in California

Hello Skip, Thanks for the reply; When I recovered from my "senior moment", I realized it was a simple application of "YEARFRAC". Sorry for the trouble. Regards, -Bob in California

Could anyone recommend a clean approach to setting up a Pro Rata Calculator in Excel. I would like to have the user be able to enter two dates and the dollar amount, and have Excel calculate the resulting pro rata dollar amount. Any help would be greatly appreciated. Thanks very much, -Bob...

You are brilliant as ever, Dale; Thanks for the reminder about database functions! Sincerely, -Bob in California