imp

  1. M

    Complex Index match or sumproduct?

    Hi I'm stuck. I have a table where I want to read the dates depending on country and row type. THEN - populate this on another table under the relevant date with a code. So here's my table I am reading from (sorry I can't paste it as a table for some reason?)...
  2. S

    sumifs with 2 sum ranges

    <tbody> Products Source Actuals<strike></strike> Plan a Loc 40 50 b Imp 50 30 c Imp 10 20 d loc 10 20 </tbody> Actuals Loc a Please share formula in cell A9 from the array A2:D5 with meeting condition in cell A6, A7 & A8. In other words I am not able to find 2 sum ranges in SUMIFS...
  3. S

    3 condition sum formula

    Please help I need formula to bring result in cell A4 based on the change condition in A1, A2 & A3 from the array B1:F10. <colgroup><col width="64" style="width:48pt" span="6"> </colgroup><tbody> A Area Source Jan Feb Mar Jan A Imp #FFFF00[/URL] , align: right"]1 2...
  4. K

    Excel increasing it's size

    Hi, I have a shared workbook in a shared drive with 12 sheets in it. 28 users work on it in same or different sheets at a time. I need to track work on sheet name "imp" on realtime basis. So i created vba to save workbook if any cell in status column in the sheet name "imp" gets updated. This...
  5. J

    Delete Line in Different Sheet Based on Cell Value and IF Statements

    I currently have a worksheet which consists of multiple sheets. On sheet "Imp. and Def. Rank Template" I enter in information which is all based on the entry number (Cell "B2") and then have a properly functioning macro which will do 1 of 3 actions depending on IF statements: 1) If the entry...
  6. J

    Using Vlookup in VBA to Find Associated Value, Copy, and Paste

    Hello, I am new to macros and am having a bit of trouble attempting to setup my code thus far. I am trying to do the following: I have a spreadsheet in Excel with multiple sheets. On sheet "Imp. and Def. Rank Template" I have essentially a form setup where I fill in various cells of...

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