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

P

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


[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]
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
You must log in or register to reply here.

Similar threads

L
  • Question Question
Macro to correct entries across multiple sheets
Replies
1
Views
262
Lux Aeterna
L
O
  • Solved
Counting instances of unique entries, with conditions
Replies
1
Views
594
ollyhughes1982
O
C
  • Question Question
Populating different sheets based on the value in a column on another sheet.
Replies
3
Views
841
DanteAmor
DanteAmor
S
  • Question Question
Find and replace a cell value if another cell value is higher
Replies
1
Views
533
Joe4
Joe4
A
  • Solved
Finding a unique value in a range and returning the value in another column of the same row, without offset / slow formulae.
Replies
8
Views
3K
AaronPMH
A

Forum statistics

Threads
1,225,754
Messages
6,186,826
Members
453,377
Latest member
JoyousOne

Share this page

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