threed

  1. S

    Rotation of 3D surface

    Hello all, I seem to be having an issue with rotating a 3D surface. I have an grid of elevation values that I have plotted to a 3D surface. I want to be able to use 2 ActiveX spin buttons to rotate the surface in the X and Y planes, in order to get a better look at the surface elevations...
  2. E

    SUMPRODUCT 3D Dynamic Reference

    Hello! Running into an issue when trying to create a 3D Sumproduct formula, which I have come to find out is not possible in MS Excel 2010 since the Morefunc add-in is not compatible, to use THREED function. Trying to figure out the work around using a "SUMPRODUCT(N(INDIRECT" function, but...
  3. U

    Very strange: vlookup shows only half of results characters!?

    Here's what is bugging me; have 2 workbooks: 1st is a production lot sheet 2nd is a weekly production planning sheet I want to type in a lot# on 1st workbook and then get all the relevant data from 2nd workbook. 2nd workbook (weekly production planning) has 52 sheets (hence 52 weeks in a...
  4. D

    local range names within Threed function?

    I am attempting to use conditionally sum across multiple tabs using the "threed' function. What I have found - using the threed function with cell references appears to work. For example this formula proves successful...
  5. R

    sumproduct with threed

    Hi everyone, I'm trying to do something that appears rather complicated to me. I'm using an array function (sumproduct) but i need to use 3d references, which arent compatible with some array functions. So, I'm using threed to change a 3d array into a 2d array. This is all to work out how many...

This Week's Hot Topics

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
Top