For each set of unique entries in column A, find the difference of 2 values in column B

[potter18]

Hi everyone,

We have the below table with around 3000+ rows and we would like to create a VBA script that will find the difference of the oldest and latest date in "TIMESTAMP_LONG" column for every unique entry in "INSTANCE_ID"

Please help. Thanks in advance

Regards
Raghav


[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 404"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]INSTANCE_ID[/TD]
[TD]TIMESTAMP_LONG[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA5EA0B147C0C8[/TD]
[TD]20181002[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA75335AE2A0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA75335AE2A0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA75335AE2A0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AA75335AE2A0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AB2B8E77E1A0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AB2B8E77E1A0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AB2B8E77E1A0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AB2B8E77E1A0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AB4F86EFBBC0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AB4F86EFBBC0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AB964D2D7300C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AB964D2D7300C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AB964D2D7300C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1ABA76EBC02E0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1ABA76EBC02E0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AC7604C66620C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AC7604C66620C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AC7604C66620C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AC7604C66620C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AC7604C66620C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AC7604C66620C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AC7604C66620C8[/TD]
[TD]20181023[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AD005409A5C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AD005409A5C0C8[/TD]
[TD]20181001[/TD]
[/TR]
[TR]
[TD]005056A612981ED8B1AD005409A5C0C8[/TD]
[TD]20181001[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]