Using Excel 2007, I have 1200+ items in inventory in Column A (each has its own ID#) and the inventory date in Column B. This returns a current total of 9581 entries. I need to know how many days each item has been in stock.
Without having to manually input Days360 after each change in ID#, is there a formula to automatically count days in inventory and insert at each change in ID#?
I copied and removed all duplicates and pasted below the data, starting in Column A Row 9586, and tried =COUNT($A$S:$A$9581,A9586,$B$2:$B:9581but that didn't work, and I also tried =Days360($A$S:$A$9581,A9586,$B$2:$B:9581without luck also. Thank you.
Bookmarks