criteria changes

  1. U

    VBA Group Row Based on Cell Critieria

    Hello Guys, I have below data that I need to group based on criteria below: Raw (Sheet1): <tbody> ID Name Status 01 Donna Done 05 Karl Complete 06 Ems Pending 02 Shawn Incomplete 05 Mae 03 Ann OK </tbody> End Result: <tbody> ID Name Status 01 Donna Done 03 Ann OK 05...
  2. C

    Excel Lookup function

    Hello, I am looking to derive a value based on a variable data set. I want take the date that is chosen and find that value in Column C then look to Column E's # that is chosen and give me the value from Column C that is that # (in this case 1) day prior to the Date I entered. Another kicker is...
  3. S

    Top 10 with multiple criteria

    Hi all, Got a database with some 175 document numbers that I need to extract the top 10 from (based on value). Have been working with a combination of INDEX, MATCH and LARGE function and I managed to get a top 10. The current code...
  4. E

    Sumif formula is changing my link to a table after I close the workbook

    I'm trying to write a sumif formula that is linking to a table and it keeps changing the formula once I save/close and then reopen the file. I highlight the column "Region" in my table (which is located in a different workbook) and it populates correctly in the formula and then when I reopen the...

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