Hi,
Ive seen similar posts but cant find what i need to do:
i have a database with many fields, "item number" is in column A and "amount in stock" is column N.
item numbers are repeated often in column A and are unsorted.
for each item appearance, i need to deduct -1 into "amount in stock" from the last time any item appeared.
i need the code to perform the following:
For example the result should be:
Item Num Amount in Stock
10802 21
10301 20
10203 17
10301 19
10502 15
10203 16
Ive seen similar posts but cant find what i need to do:
i have a database with many fields, "item number" is in column A and "amount in stock" is column N.
item numbers are repeated often in column A and are unsorted.
for each item appearance, i need to deduct -1 into "amount in stock" from the last time any item appeared.
i need the code to perform the following:
For example the result should be:
Item Num Amount in Stock
10802 21
10301 20
10203 17
10301 19
10502 15
10203 16