arrary formulas

  1. A

    VBA Function for Hidden Cells

    Hey guys, I am pretty good with Excel, but am new to programming with VBA. I am trying to make a function that will only show the value of visible cells (so I can have excel calculate a slope/offset of a filtered table. I made the function below, and it seems to work pretty well. Option...
  2. T

    Formula to Count Unique ID numbers per month

    I need to count how many unique ID numbers there are per month.I have figured out how to count the unique ID's for the first month (Jan) but after that I'm having trouble trying to get the count right for Feb and Mar. Formula I used in cell E2 is...
  3. T

    Help writing a Macro with multiple formulas in one

    Ok everybody this is my first post and I am completely stumped! I work for a company where we track our employees times by using gps time stamps through an iphone application. Here is the way I invision the spreadsheet working. The Meta data from the gps pings from the employees phones comes...
    • TracesVA
    • Thread
    • arrary formulas geo fencing macro and formula multiple cell reference multiple cell values
    • Replies: 2
    • Forum: Excel Questions
  4. S

    Array Formulas Not Updating

    I'm working in a sales summary file, and I'm using the following formula: {=(SUMPRODUCT(TRANSPOSE('2013 Market Matrix'!$U$17:$BJ$17),'Top 40C by Month vs PY'!E$8:E$49))} The purpose of this is to take sales dollars from customers and run that against a series of percentages to determine sales...
    • Spangles
    • Thread
    • arrary formulas not updating range values sumproduct arrays transpose data
    • Replies: 0
    • Forum: Excel Questions

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