functional

  1. K

    SUMPRODUCT or SUMIFS .What is the better approach to solve the problem

    Friends , I tried my best , but need help. Table 1 contains time sheet information . hrs ,project id, manager/resource names(2 levels only) I have been asked to get total hrs grouped by managers Managers list : Randy, Srini, Kavin Table 1 <tbody> EMP_HRS PROJECTID L1 NAME L2 NAME Type 1...
    • Kumarxl
    • Thread
    • functional id12345 randy sumifs sumproduct arrays
    • Replies: 5
    • Forum: Excel Questions
  2. C

    Excel to HTML

    Is it possible to convert a simple user input excel file to HTML and it still be functional? I have tried the "save as" option and it looks great but is not functional. In my example, columns A & B are user input and the remaining are resulting output. Thanks for any help! Excel 2010...
  3. T

    Write-over a formula in a cell using, but preserve the formula.

    I have a cell with this formula in it; it is actually in a range of cells (I11:K25) but the row number changes. =IF($H11="Fully Functional", "N/A","") The challenge or my questions is how do I preserve/retain the formula in the cell when a user writes over it and them later changes his/her...

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