01/01/2015

  1. D

    merging data in one row

    <tbody> ID Part number Kind manf. date comments 300 100 L 09/05/2001 toyota 300 101 R 06/03/2001 toyota 301 200 L 01/01/2015 Honda 301 201 R 01/01/2015 Honda 302 300 L 01/03/2012 Nissan 302 301 R 01/05/2014 Nissan </tbody> After merging...
  2. F

    count of cells based between 2 dates, removing duplicates from criteria based on 3 other columns

    I am looking for a couple of tweaks to an existing formula which I just cant find the logic to What I am trying to do is create a formula that will count all the dates in column “U” based on a criteria of a date that is in cell “I4” (this is a fixed date). What I want to do is to make this...

This Week's Hot Topics

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
Top