EXCEL 2013 Sheet and blocks

Gideondb

New Member
Joined
Feb 24, 2019
Messages
23
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: 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="width: 115"]
<tbody>[TR]
[TD="class: xl63, width: 115"]Barcode no[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR]
[TD="class: xl65, width: 136"]Serl. no.[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 208"]
<tbody>[TR]
[TD="class: xl67, width: 208"]Item Name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]Units[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD="class: xl65, width: 112"]Price[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][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="width: 102"]
<tbody>[TR]
[TD="class: xl65, width: 136"]BWStock00005[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][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: grid, width: 300"]
<tbody>[TR]
[TD]BWStock00001[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/03/2019 05:43:43 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/04/2019 02:03:45 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 155, align: right"]03/10/2019 09:35:55 AM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 104, align: right"]BWStock00005[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: xl65, width: 154, align: right"]03/03/2019 05:46:07 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="class: 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? :confused:

Thank You
Gideon
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

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