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

potter18

New Member
Joined
Nov 12, 2018
Messages
1
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


INSTANCE_IDTIMESTAMP_LONG
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181001
005056A612981ED8B1AA5EA0B147C0C820181002
005056A612981ED8B1AA75335AE2A0C820181001
005056A612981ED8B1AA75335AE2A0C820181001
005056A612981ED8B1AA75335AE2A0C820181001
005056A612981ED8B1AA75335AE2A0C820181001
005056A612981ED8B1AB2B8E77E1A0C820181001
005056A612981ED8B1AB2B8E77E1A0C820181001
005056A612981ED8B1AB2B8E77E1A0C820181001
005056A612981ED8B1AB2B8E77E1A0C820181001
005056A612981ED8B1AB4F86EFBBC0C820181001
005056A612981ED8B1AB4F86EFBBC0C820181001
005056A612981ED8B1AB964D2D7300C820181001
005056A612981ED8B1AB964D2D7300C820181001
005056A612981ED8B1AB964D2D7300C820181001
005056A612981ED8B1ABA76EBC02E0C820181001
005056A612981ED8B1ABA76EBC02E0C820181001
005056A612981ED8B1AC7604C66620C820181001
005056A612981ED8B1AC7604C66620C820181001
005056A612981ED8B1AC7604C66620C820181001
005056A612981ED8B1AC7604C66620C820181001
005056A612981ED8B1AC7604C66620C820181001
005056A612981ED8B1AC7604C66620C820181001
005056A612981ED8B1AC7604C66620C820181023
005056A612981ED8B1AD005409A5C0C820181001
005056A612981ED8B1AD005409A5C0C820181001
005056A612981ED8B1AD005409A5C0C820181001

<colgroup><col><col></colgroup><tbody>
</tbody>

<tbody>
</tbody>
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top