EXCEL 2013 Sheet and blocks

[Gideondb]

[h=2]EXCEL 2013 Sheet and blocks[/h]

I need to count all blocks with the date and time in it as a unit in a block .F3 sheet Donnie and keep it up to count.

This is what i have at the moment but need to add on it.

I have two sheets , in sheet Donnie block A1 you scan a barcode , then it writes the Barcode in A1 sheet DDATA(2nd sheet) and the date and time in sheet DDATA (2nd sheet) in block B1 and if you scan in A1(sheet Donnie)same barcode again, it places another date and time in sheet DDATA block C1 and so on , next D1 if it the same barcode. If it is a other barcode it place the Barcode in A2 and the date and time in B1 .This is wat i want, that is fine.
I now want to count all the date and time blocks for that Barcode row as units in Sheet Donnie F3 and keep it counting as new scan happens. ?

Sheet Donnie
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="class: cms_table, width: 115"]
<tbody>[TR]
[TD="class: cms_table_xl63, width: 115"]Barcode no[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="class: cms_table, width: 136"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 136"]Serl. no.[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="class: cms_table, width: 208"]
<tbody>[TR]
[TD="class: cms_table_xl67, width: 208"]Item Name[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="class: cms_table, width: 86"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 86"]Units[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="class: cms_table, width: 112"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 112"]Price[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="class: cms_table, width: 459"]
<tbody>[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD]BWStock00001[/TD]
[TD]Stick lights[/TD]
[TD]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][TABLE="class: cms_table, width: 102"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 136"]BWStock00005[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="class: cms_table, width: 459"]
<tbody>[TR]
[TD]Removable red fridge hinges[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD]?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Sheet DDATA
[TABLE="class: cms_table_grid, width: 300"]
<tbody>[TR]
[TD]BWStock00001[/TD]
[TD][TABLE="class: cms_table, width: 116"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 154, align: right"]03/03/2019 05:43:43 PM[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="class: cms_table, width: 116"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 154, align: right"]03/04/2019 02:03:45 PM[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="class: cms_table, width: 116"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 155, align: right"]03/10/2019 09:35:55 AM[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="class: cms_table, width: 78"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 104, align: right"]BWStock00005[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="class: cms_table, width: 116"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 154, align: right"]03/03/2019 05:46:07 PM[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="class: cms_table, width: 116"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 154, align: right"]03/03/2019 05:46:44 PM[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


So in sheet Donnie block F3 it should count the dates as a unit 3 ?
and in Donnie block F4 should count 2 units ?

Please help?

Thank You
Gideon​

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...013-sheet-blocks-post5240259.html#post5240259

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.