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
Barcode no

<tbody>
</tbody>
Serl. no.

<tbody>
</tbody>
Item Name

<tbody>
</tbody>
Units

<tbody>
</tbody>
Price

<tbody>
</tbody>
1

<tbody>
</tbody>
BWStock00001Stick lights?
5
BWStock00005

<tbody>
</tbody>
Removable red fridge hinges

<tbody>
</tbody>
?

<tbody>
</tbody>

Sheet DDATA
BWStock00001
03/03/2019 05:43:43 PM

<tbody>
</tbody>
03/04/2019 02:03:45 PM

<tbody>
</tbody>
03/10/2019 09:35:55 AM

<tbody>
</tbody>
BWStock00005

<tbody>
</tbody>
03/03/2019 05:46:07 PM

<tbody>
</tbody>
03/03/2019 05:46:44 PM

<tbody>
</tbody>

<tbody>
</tbody>

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
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,108,985
Messages
5,526,063
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top