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...
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...
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)
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.