Hello,
Can I please get some help with a macro, I put the columns and rows in to better define what I'm looking for. The keys for me are column B and column D.
Row 2 and row 3 have the same unit number whenever this is identified look at column D and only keep the row with the most current time. In this example row 3 would be kept and row 2 deleted from the spreadsheet.
My spreadsheet will have up to 100000 rows of data. Thank you all.
Tried to attach a spreadsheet but not sure I did it correctly, that's why I added the data here. Thanks
[TABLE="class: cms_table_cms_table, width: 464"]
[tr][td]Column A
[/td][td]Column B
[/td][td]Column c
[/td][td]Column D
[/td][td]Column E
[/td][td]Column F
[/td][/tr][tr][td]Row 1
[/td][td]Green Jacket
[/td][td]Created On
[/td][td]Created At
[/td][td]Product
[/td][td]Grams Weight
[/td][/tr][tr][td]Row 2
[/td][td]Unit 1
[/td][td]5/1/2015
[/td][td]17:00:40
[/td][td]A
[/td][td]71.907
[/td][/tr][tr][td]Row 3
[/td][td]Unit 1
[/td][td]5/1/2015
[/td][td]17:23:56
[/td][td]A
[/td][td]264.216
[/td][/tr][tr][td]Row 4
[/td][td]Unit 2
[/td][td]5/1/2015
[/td][td]17:02:48
[/td][td]A
[/td][td]71.907
[/td][/tr][tr][td]Row 5
[/td][td]Unit 2
[/td][td]5/1/2015
[/td][td]17:24:04
[/td][td]A
[/td][td]264.216
[/td][/tr][tr][td]Row 6
[/td][td]Unit 3
[/td][td]5/1/2015
[/td][td]17:03:02
[/td][td]A
[/td][td]71.907
[/td][/tr][tr][td]Row 7
[/td][td]Unit 3
[/td][td]5/1/2015
[/td][td]17:24:12
[/td][td]A
[/td][td]264.216
[/td][/tr][tr][td]Row 8
[/td][td]Unit 4
[/td][td]5/1/2015
[/td][td]17:03:17
[/td][td]A
[/td][td]71.907
[/td][/tr][tr][td]Row 9
[/td][td]Unit 4
[/td][td]5/1/2015
[/td][td]17:24:23
[/td][td]A
[/td][td]264.216
[/td][/tr][tr][td]Row 10
[/td][td]Unit 5
[/td][td]5/1/2015
[/td][td]17:03:30
[/td][td]A
[/td][td]126.255
[/td][/tr][tr][td]Row 11
[/td][td]Unit 5
[/td][td]5/1/2015
[/td][td]17:24:35
[/td][td]A
[/td][td]464.887
[/td][/tr][tr][td]Row 12
[/td][td]Unit 6
[/td][td]5/1/2015
[/td][td]17:03:44
[/td][td]A
[/td][td]71.907
[/td][/tr][tr][td]Row 13
[/td][td]Unit 6
[/td][td]5/1/2015
[/td][td]17:24:47
[/td][td]A
[/td][td]264.216
[/td][/tr][tr][td]Row 14
[/td][td]Unit 7
[/td][td]5/1/2015
[/td][td]17:03:56
[/td][td]A
[/td][td]71.907
[/td][/tr][tr][td]Row 15
[/td][td]Unit 7
[/td][td]5/1/2015
[/td][td]17:24:58
[/td][td]A
[/td][td]264.216
[/td][/tr][tr][td]Row 16
[/td][td]Unit 8
[/td][td]5/1/2015
[/td][td]17:04:14
[/td][td]A
[/td][td]71.907
[/td][/tr][tr][td]Row 17
[/td][td]Unit 8
[/td][td]5/1/2015
[/td][td]17:25:10
[/td][td]A
[/td][td]264.216
[/td][/tr]
[/TABLE]