How can I create a range in Column B based on repetitive values from Column A?

[Madridic1]

1 1 Here is what my data looks like. I am trying to create a code that identifies all the rows with the same values in column A, and then
1 3 finding the MAX-MIN within column B of those rows. I am a beginner to VBA and this has been frustrating me for the past two days, plz
1 4 help !!!
1 2
1 3
1 2 For example - Within all rows with "1" in Column A. The MAX is 5, and MIN is 1 for column B therefore the range is 4.
1 2 - Within all rows with "2" in Column A. The MAX is 7, and MIN is 2 for column B therefore the range is 5.
1 3 - Within all rows with "3" in Column A. The MAX is 9, and MIN is 3 for column B therefore the range is 6.
1 3
1 5
2 6
2 6
2 7
2 3
2 2
2 3
2 4
2 5
2 6
3 4
3 3
3 5
3 7
3 8
3 9

[kersplash]

I did this using two pivot tables.

One to get the min and max values, and the second one uses the first pivot table as the source and uses a calculated field to subtract the min from the max.

[Olly]

It's pretty trivial using Power Query:

Please Login or Register  to view this content.