Hi,
I need a little help with making criteria in excel. As is evident from the image attached here is a simple order by the scanner. Using COUNTIF formula I made that every bar code that is scanned in row "K" verify barcodes "B" and thus get a result in the row of the "H" and "I". In this case, the order of "B" me as a base. What interests me now, how do I make the criteria in the case to be scanned bar code that is not in the right "B". I would want to throw me a pop up window in which to write the "wrong bar code"
B.R.
I need a little help with making criteria in excel. As is evident from the image attached here is a simple order by the scanner. Using COUNTIF formula I made that every bar code that is scanned in row "K" verify barcodes "B" and thus get a result in the row of the "H" and "I". In this case, the order of "B" me as a base. What interests me now, how do I make the criteria in the case to be scanned bar code that is not in the right "B". I would want to throw me a pop up window in which to write the "wrong bar code"
B.R.
