There is a list of numbers as shown below

Date [Column A], occurrence [Column B]
14-Jun, 2
14-Jun, 2
17-Jun, 1
15-Jun, 3
23-Jun, 2
16-Jun, 2
26-Jun, 2
17-Jun, 2
05-Jul, 1
19-Jun, 2

I would like to sort the list in ascending order and determine the total
occurrences for each date. As shown below

14-Jun, 4
15-Jun, 3
16-Jun, 2
17-Jun, 3
19-Jun, 2
23-Jun, 2
26-Jun, 2
05-Jul, 1

Does anyone have any suggestions on how to do it?
Thank in advance for any suggestions
Eric

Step 1 would be to create a list of the unique dates, which you can do with
Data, Filter, Advanced Filter. Step 2 would be to use the SUMIF worksheet
function to get the total for each unique date. Step 3 would be to sort
descending on the SUMIF results.

--
Jim
"Eric" wrote in message
...
| There is a list of numbers as shown below
|
| Date [Column A], occurrence [Column B]
| 14-Jun, 2
| 14-Jun, 2
| 17-Jun, 1
| 15-Jun, 3
| 23-Jun, 2
| 16-Jun, 2
| 26-Jun, 2
| 17-Jun, 2
| 05-Jul, 1
| 19-Jun, 2
|
| I would like to sort the list in ascending order and determine the total
| occurrences for each date. As shown below
|
| 14-Jun, 4
| 15-Jun, 3
| 16-Jun, 2
| 17-Jun, 3
| 19-Jun, 2
| 23-Jun, 2
| 26-Jun, 2
| 05-Jul, 1
|
| Does anyone have any suggestions on how to do it?
| Thank in advance for any suggestions
| Eric
|

Thank you for your suggestions
I don't want to use Data, Filter, Advanced Filter, do you have another
approach to create a list of the unique dates?
Thank you for any suggestions
Eric

"Jim Rech" wrote:

Step 1 would be to create a list of the unique dates, which you can do with
Data, Filter, Advanced Filter. Step 2 would be to use the SUMIF worksheet
function to get the total for each unique date. Step 3 would be to sort
descending on the SUMIF results.

--
Jim
"Eric" wrote in message
...
| There is a list of numbers as shown below
|
| Date [Column A], occurrence [Column B]
| 14-Jun, 2
| 14-Jun, 2
| 17-Jun, 1
| 15-Jun, 3
| 23-Jun, 2
| 16-Jun, 2
| 26-Jun, 2
| 17-Jun, 2
| 05-Jul, 1
| 19-Jun, 2
|
| I would like to sort the list in ascending order and determine the total
| occurrences for each date. As shown below
|
| 14-Jun, 4
| 15-Jun, 3
| 16-Jun, 2
| 17-Jun, 3
| 19-Jun, 2
| 23-Jun, 2
| 26-Jun, 2
| 05-Jul, 1
|
| Does anyone have any suggestions on how to do it?
| Thank in advance for any suggestions
| Eric
|

Another way...
Select a cell outside the table then DataConsolidate with options
Reference: A:B and labels in left column. Format first col as dates.

On 15 Jun, 01:32, Eric wrote:
Thank you for your suggestions
I don't want to use Data, Filter, Advanced Filter, do you have another
approach to create a list of the unique dates?
Thank you for any suggestions
Eric



"Jim Rech" wrote:
Step 1 would be to create a list of the unique dates, which you can do with
Data, Filter, Advanced Filter. Step 2 would be to use the SUMIF worksheet
function to get the total for each unique date. Step 3 would be to sort
descending on the SUMIF results.

--
Jim
"Eric" wrote in message
...
| There is a list of numbers as shown below
|
| Date [Column A], occurrence [Column B]
| 14-Jun, 2
| 14-Jun, 2
| 17-Jun, 1
| 15-Jun, 3
| 23-Jun, 2
| 16-Jun, 2
| 26-Jun, 2
| 17-Jun, 2
| 05-Jul, 1
| 19-Jun, 2
|
| I would like to sort the list in ascending order and determine the total
| occurrences for each date. As shown below
|
| 14-Jun, 4
| 15-Jun, 3
| 16-Jun, 2
| 17-Jun, 3
| 19-Jun, 2
| 23-Jun, 2
| 26-Jun, 2
| 05-Jul, 1
|
| Does anyone have any suggestions on how to do it?
| Thank in advance for any suggestions
| Eric
|- Hide quoted text -

- Show quoted text -