1/2/18

  1. N

    Conditional Copy and paste

    Hello, I have a sheet of data where column one is a list of names and column two is a list of dates. Some names have multiple dates (multiple entries). I need help writing a macro that copies and pastes the rows of data onto a new sheets and if a name is repeated the rows are pasted together on...
  2. B

    count the number of times a date is shown.

    i have a list of files with dates associated. i'd like to simply count the number of times each date is being shown. for example, 1/2/18 is shown below 10 times. I have this for an entire calendar year. <colgroup><col></colgroup><tbody> 1/2/18 1/2/18 1/2/18 1/2/18 1/2/18 1/2/18...
  3. W

    Combining Dates to Make Chart

    I am trying to make a chart with some of the same dates and each date equals 1. I want to combine the same dates and have it add them all up. EXAMPLE: 1/1/18 1/1/18 1/1/18 1/2/18 1/2/18 So I want to combine the dates into a chart row and the column be the number of date's combined (1/1/18 = 3)

Watch MrExcel Video

Learn Excel 2013 - &quot;Chart Legend Changes&quot;: Podcast #1693

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