Search results for query: *

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

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

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

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

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

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

I would like to have a PercentRank wksht set up whereby if a value in the array is equal to one or more other values, the "tie-breaker" would depend on the value in an adjacent column. Col A Col B Rank 119 81 100% 118 79 88% 115 71 25% 115 75 25% 115 68 25% 115 72 25% 115 73 25% 114 72 13%...

Just a general question which I haven't been able to resolve: Are there any computational advantages of using an OLAP cube, as compared with using a pivot table. I can't seem to find any real benefits, and I am wondering if it is worth my while to become more informed about cubes. Any...

I have a simple OLAP cube that I want to add a calculated field to, but the option is grayed out under formulas. I am a bit new to pivot tables, but I have followed instructions (books) carefully, but to no avail. Am I doing something wrong, or is this an aspect of an OLAP cube? Any help...

This is a bit off-the-wall, but does anyone have any suggestions as to how to create a "reverse crosstab query" in Excel, whereby the values in a crosstab-style table are put into a standard database field format? Any help would be greatly appreciated! Thanks very much, -Bob in California

I am building a Table of Contents at the beginning of this PowerPoint presentation, and would like to hyperlink of the TOC to the various slides. In spite of various work-around attempts, I occasionally cannot get a hyperlink to go to a particular slide. No other problems with similar...

Is there a relatively simple way (being simple-minded...) to limit access to a particular form for which there is a button on the switchboard? I want to make one of the forms accessible only to the manager of the department. Could a password be assigned to a button/form? Any help would be...

I am using the Rand() function in a worksheet, and would like to be able to link a macro to a button (I know how to do that part) that would enable the user to recalculate the worksheet. The problem is that I am basically ignorant when it comes to VBA and the needed macro to do this manual...

This one has been eluding me for some time. Is there a way to populate an email address according to a name chosen on a form (in a combo box)? I want to be able to click a button on the form and have a report attach to an email that is addressed according to the current choice on the form...

Is it possible to build a query (the information will be used on a report) which uses the information currently chosen in a combo box on a form. For instance, in a field on the query entitled, "Agent", Agent=[current value on main form]. (Sorry for the ignorant example) I am using Access...

Access Newbie here: Is there a simple way to have a second field completed dependant on the value chosen in a combo box? Any help will, as always, be very appreciated. Thanks, -Bob in California

Elementary question from an elementary Access user: How do you specify which field/column you want to draw from for a Combo Box item? I don't understand how to do this using the properties. For example, when I choose an "Employee" table to use as the source for a combo box dropdown, I end up...

This one is stumping me. I have two ranges I want stacked on a chart, with an additional range as a column on same chart. Day DM Other Capacity Monday 1367 505 1590 Tuesday 1245 472 1526 Wednesday 1147 446 1526 Thursday 1055 525 1526 Friday 896 476 1558 DM and...

I am afraid this is a bit naiive, but how do you set the properties of a form to start at a New Record (vs. the beginning of the data) each time the form is freshly opened? Any advice will be greatly appreciated. Thanks very much, -Bob in California

Old Excel wiz here, but a Newbie to Project (and feeling very humble...). I want to set the default on my master project to have all subprojects (and sub-subprojects) roll up to the summary item above them. I am sure this is simple, but I would very much appreciate some advice. Thanks very...