excel 2010 problem

  1. A

    Combining Sumproduct and Frequency to sum weights by quarter

    I'm tracking my students grades per quarter and using a weight system. I have been able to gather some of the information I need however I am stuck at how to have the below formula only take into account one particular grading quarter. This formula gives me the overall grade for the course but I...
  2. S

    FIFO Help

    I'm looking for some help with doing a FIFO calculation for multiple item numbers. I was wondering if someone could help me out with this. Here is a sample data for people to view while trying to create something that might work. Output is the units being created and sale is obviously the sale...
  3. S

    links change when emailed as an attachment?

    Hi im sending an excel (2010) file as an attachment over outlook. the file is located on a netwrok drive that both me and the recipient have acces to. some cells are linked to another file on the same network drive(actually only one directory up) when i send the file to a colleague, again he...
  4. F

    Excel spontaneously changing colors of individual cells

    All, I have an issue with Excel 2010 spontaneously changing coloring of some cells. I have a simple VBA macro which creates and populates sheets in a new workbook, copying all formatting information from the original workbook. Occasionally the formatting gets changed while the macro is running...
  5. C

    Staticdate() designed in 2003 not working in 2010

    Hi everyone. I have designed a spreadsheet in 2003 which uses staticdate in a formula e.g. =IF(C34="y",StaticDate()). It works perfectly fine in Excel 2003 but when I open it in Excel 2010 it returns the current date i.e. the date the spreadsheet is being opened on. When I re-open in in 2003...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top