offshore

  1. H

    Require formula to get status based on count and char

    Team, I am looking for some formula to get the require project status "Yes" or "No". Here I have sample data. If you look at project name is repeating and project type have both onshore and offshore. I would need to get status "Yes" if any project worked on both project types. If in case...
    • harinsh
    • Thread
    • count & count ifs duplicate data count offshore onshore project
    • Replies: 3
    • Forum: Excel Questions
  2. S

    Remove Duplicate (Sort of) Row based on => Value in another Cell

    I need to add this to a Macro I am working on and this one is beating me right now. Any help is much appreciated. These are columns B,C,D and E in my spreadsheet. What I am trying to accomplish is if there is a duplicate value in column "B" to evaluate the numbers in column "E". If the numbers...
    • slpswhite
    • Thread
    • 11/17/2017 column offshore remove duplicate rows remove duplicate values
    • Replies: 9
    • Forum: Excel Questions

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