Hi Rick,

Actually the WIP no. is one of the possible result that I might be looking for. Each line will provide a parts number, qty and a order number (although this order number is only a 4 digit like AV3T and AV3U etc.,)

It supposed that it is not allowed to have blank in WIP no, but from my understanding, it is potentially if I ordered the same parts number in same qty at the same order. Then when the goods received, I might have two identical line to fit into my list that I need to find the another way to solve it.

In my personal thinking, I might need to use three criteria to search on my list in the future, now I hope I can understand the theory and do it by myself.

Thanks Admin,

But I tried to copy the formula you teach me, Im not sure are you mean I have to input "zzzzzzzzz" at the last row?