I have a column of dates (Column A) with intermittent blanks and I need to display the number of occurrences for each unique date.
This is what I am starting with: (Note= The number of rows varies by project so I need the whole Column A referenced)
<tbody>
</tbody>
This is how I envision it ending up:
<tbody>
</tbody>
This is what I am starting with: (Note= The number of rows varies by project so I need the whole Column A referenced)
Dates | ||
02-24-2013 | ||
02-24-2013 | ||
12-15-2012 | ||
11-26-2012 | ||
02-24-2013 | ||
02-24-2013 | ||
11-25-2012 | ||
11-25-2012 |
<tbody>
</tbody>
Column A= Dates
This is how I envision it ending up:
Dates | Unique Dates | Number of Occurrences |
02-24-2013 | 02-24-2013 | 4 |
02-24-2013 | 12-15-2012 | 1 |
12-15-2012 | 11-26-2012 | 1 |
11-25-2012 | 2 | |
11-26-2012 | ||
02-24-2013 | ||
02-24-2013 | ||
11-25-2012 | ||
11-25-2012 |
<tbody>
</tbody>
Column A= Dates
Column B= Unique Dates
Column C= Number of Occurrences for Adjacent Unique Date against Column A
Thanks in advance, TerryColumn B= Unique Dates
Column C= Number of Occurrences for Adjacent Unique Date against Column A
Last edited: