Description:
Microsoft Office Excel newsgroup.
|
|
|
DIV/0 error
|
| |
I have a workbook that gives the %age profit of products sold on a month basis. Each month has a separate worksheet to allow for identifcation of variances from expected on a monthly basis. I want to summarise the monthly data by supplier and have created a worksheet using the SUMIF function to pull the information through from the individual monthly sheets. =SUMIF([Profit],[SupplerName], [Sales])/SUMIF([Profit],[Suppl erName],[Sales])... more »
|
|
|
A few problems involving LOOKUP and SUMPRODUCT...
|
| |
Hi all, I am putting together a spreadsheet for a weight watching club. There are 6 members, and a weight entry will be recorded each friday from 08/01/10 - 01/04/10. The weight will be entered in total lbs e.g. 142.25 and the data range is B26:N31. Each members weight will be recorded in this range, i.e.... more »
|
|
|
Delete drop down list
|
| |
I see instructions for creating drop down lists, but not for deleting them. I have a list that is no longer useful and would like to delete it from the worksheet (To clarify: I am talking about removing the list from the list of list names that appears when using the F3 key) Thank you
|
|
|
Worksheet name
|
| |
Hi What should i do so that the Worksheet (Tab) name is the same as what i type in a specific cell? Regards,
|
|
|
Data Validation drop-down
|
| |
I have a cell with data validation drop-down in it. If I've already chosen an item the list opens next time with tht item at the top of the list - can't see the ones at the top unless I scroll up. I want it to open showing the beginning of the list each time. Can I control how it opens? I am OK with a VBA solution if that's the only way to do it, too. but how... more »
|
|
|
Need a formula that will do C1=A1*B1...Cn=An*Bn
|
| |
Suppose column A has "quantity" values, column B has "amount" values, and I want column C to be their products. I have 950 rows of this and I don't want to enter 950 formulas into each row of C. In other words I need Cn=An*Bn where n=row number. Thanks
|
|
|
Office 2010
|
| |
Hi, I have been doing some testing on Excel 2010 and testing out the 32 bit addinn application(which contains vba addins, c++ libraries and VB libraries). And this seems to be working fine with 32 bit version of office and as expected its not working with 64 bit version one. Can some one confirm that to work with office 2010 64 bit, any client... more »
|
|
|
employee business chart
|
| |
I want to create an employee business chart that shows from the top down department managers and each of their duties using Microsoft Home and School 2007
|
|
|
averages/if formulas-need help ASAP!!
|
| |
I have two columns: one has initials of person completing the task, next to it is the percentage of work that is equal to. At the bottom, I am hoping to have two tables depicting the average % of work and total % of work for each person. I've tried =average(e3:e23 (if(d3:23="dj")) Basically I have no idea how to create a correspondence between the name and... more »
|
|
|
Assign Macro to Icon on toolbar
|
| |
I want to assign a macro (error message) to the SAVE icon on the Standard Toolbar to disable that save function to get the user to use the save button I have set up on the Sheet. I know it can be done because I have it on a spreadsheet someone elsse set up but I cannot find where they set it up. THANKS for any help.... more »
|
|
|
|
