Home |
Search |
Today's Posts |
#1
|
|||
|
|||
max and lookup
I have 2 columns of data; my item number and amount of quantity reserved. I
want to be able to get the max of a quantity reserved by looking up the item number. For example, I want to find out the max on Quantity for Item #100 = 10. Item # Quantity 101 5 100 10 102 4 100 8 102 9 101 11 |