4/2/2018

  1. M

    macro or logic to remove duplicates by time/date

    I’ve got a problem with removing duplicates from set of data Column A is a client Column B is a product Column C is the date when it’s effective What I want to do is few steps which I can’t figure out how tocombine: Sort by columnC – Newest to oldest Removeduplicate rows – here’s the...
    • Mehow
    • Thread
    • 10/1/2018 4/2/2018 7/2/2018 chamm075x703 chamm075xx04
    • Replies: 1
    • Forum: Excel Questions
  2. Z

    Looking up dates and splitting a travel cost evenly

    Hi, I want a formula that will look up dates and split a travel cost evenly for contractors. For example: If they work on two jobs on one day, I want to split the daily travel costs evenly. 1/1/2018 Job A 8 hours 2/1/2018 Job A 4 hours 2/1/2018 Job B 4 hours 3/2/2018 Job C 8 hours 4/2/2018...
  3. E

    How do I do a Count distinct of a column ?

    If I have a table like this, that's like an audit table of dates users run reports. Report User Date Fin Fred 1/2/2018 Fin Fred 2/2/2018 Fin John 1/2/2018 HR Fred 3/2/2018 HR Fred 4/2/2018 HR Steve 4/2/2018 HR...

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