Hey everyone,
New to this forum but I'm sure I will be posting more to get help as I work on making my projects a little more automated and easier for me to use. I'm trying to count a number of products on a shelf by using a shelf code or position as a reference.
Shelf codes are labeled as DF1-1-A which means it is on row 1 shelf 1 position A. So I have a list of products with their relative position but can't figure out how to make it look for every product that is in for example DF10-2-[A-Z] and count the positions only. Any ideas?
I'm open to using macros as well but I'm trying to avoid them and see if its possible with a function instead.
Here is some data to work with :
DF10-1-A 931100477
DF10-2-A 931100480
DF10-3-A 931100750
DF10-3-B 931100808
DF10-4-A 931100251
DF10-4-B 931100878
DF10-5-A 931100817
DF10-5-B 931100755
DF10-6-A 931100250
DF10-6-B 931100811
DF10-7-A 100105105
DF10-7-B 100105113
DF11-1-A 931100279
DF11-2-A 931100290
DF11-3-A 931100280
DF11-4-A 931100239
DF11-4-B 931100243
DF11-6-A 931100719
DF11-7-A 931100241
Bookmarks