View Single Post
  #5   Report Post  
gordo
 
Posts: n/a
Default excel array formula

THE SAME SKU CAN APPEAR MULTIPLE TIMES ON THE SPREADSHEET.i HAVE WITH
SOMEONES HELP BEEN ABLE TO DETERMINE THE LAST TIME IT WAS COUNTED.
HOWEVER I WANT TO BRING BACK THE QTY AND QTY COUNTED AS WELL.
FOR EXAMPLE:

SKU 276262 QTY 10 QTY COUNTED 12 DATE 5TH DEC
THEN ANOTHER SKU
AND ANOTHER
THEN THE SKU RE-APPEARS WITH DIFFERENT QTY AND DATE

I WANT TO BRING BACK THE QTY AND QTY COUNTED THE LAST TIME IT WAS
COUNTED


RGDS

GORDON