specifically

  1. R

    Find/Paste Values

    hi. For a specific range of cells that I define, I would like to search for a particular piece of text within the formula - if found, paste values and then move on to the next. Specifically, I'm trying to paste values for all vlookup formulas in a range of cells in a worksheet. Can someone help...
  2. L

    Best online classes/tutorials to take

    I was wondering what would be the best courses/classes to take that start at medium/advance knowledge of excel. It seems every tutorial starts with very basic functions (SUM, Vlookups), I want to specifically get into the weeds with macros and learn how to code them. Just curious what your guy's...
  3. D

    Dynamic Range Formula or Non Contiguous Single Column Based on Value of 2nd Column?

    After trying a few options and searching for the last couple hours can't seem to find a way to have a dynamic range that will select the cells in Column B if the corresponding value in Column A is equal to a specific value ("Y"). Any info on how I could accomplish this is appreciated. FYI, I...
  4. R

    SUMIF l;ooks for multiple text options

    I’m using these two formulas to sum the data in the appropriatecells: =SUMIF($C$4:$C$200,"ORANGE",D$4:D$200) =SUMIF($C$4:$C$200,"BLUE",D$4:D$200) Both work perfectly. Now I need a formula that will sum thetotal if instead of looking specifically for ORANGE or BLUE, it looks for GREENor...

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