Generate column of all values and the number of times they occur

[shapeshiftingkiwi]

Hello,

I'm starting with columns B and C and my desired output is column A. Column A gives the values in column B and the number of times they occur (column C). My actual use case is much larger and it's tedious to do this manually. Hoping this is as straightforward as I feel like it should be.

Master Brown Worksheet.xlsx
	A	B	C
1	All Pumpkins	Prize Pumpkin Weight	Number of Prize Pumpkins at this Weight
2	800	800	3
3	800	556	1
4	800	874	2
5	556	800	2
6	874
7	874
8	800
9	800
Sheet4

Thanks!

 

[mumps]

Try:

Sub GenerateValues()
    Application.ScreenUpdating = False
    Dim rng As Range
    For Each rng In Range("B2", Range("B" & Rows.Count).End(xlUp))
        Cells(Rows.Count, "A").End(xlUp).Offset(1).Resize(rng.Offset(, 1)).Value = rng
    Next rng
    Application.ScreenUpdating = False
End Sub

 

[shapeshiftingkiwi]

Not as simple as I would have thought but I figured it out! My first VBA, thanks!

 

[mumps]

You are very welcome.