Hi, I have a running Sheet wih ColB containing Product ID# and I "manually" enter in ColG The Equipment used for this production, (example AR12, TK7, etc.).
I would very much appreciate if I can just enter a Furmula in coG which will Search previous production of that Product ID# (in ColB of same sheet) and then enter (as Default) the Equipment # which was most used for that Product.
So, if I enter in Row1200 ColB Product Id# 1234 it will look up the sheet and see that #1234 was made 3 times in Equipment # TK7 and once in #AR12 and automatically fill Row1200 ColG TK7.
I would very much appreciate if I can just enter a Furmula in coG which will Search previous production of that Product ID# (in ColB of same sheet) and then enter (as Default) the Equipment # which was most used for that Product.
So, if I enter in Row1200 ColB Product Id# 1234 it will look up the sheet and see that #1234 was made 3 times in Equipment # TK7 and once in #AR12 and automatically fill Row1200 ColG TK7.
