Hello,
Im very new to excel and am basically stumbling my way through. I oversee a warehouse where I scan serialized equipment to technicians. I'm trying to set up a FIFO metric for the equipment so that the technicians can make sure they're using the oldest pieces of equipment before the newest. I just have no idea how to do it. I can get percentages between dates I.E between 4/30/2019-5/3/2019. But it's not calculable, I want to see the percentage for 1 person instead of from one column. I've been looking online for FIFO help but all I see are large sales and not individualized for equipment and date ranges. any help would be great.
example
George 0000019018 On Hand / 4/29/2019
George 00001877 Consumed /INS 4/29/2019 5/1/2019
George 000018952 Consumed /INS 4/29/2019 4/30/2019
George 0001004443 Consumed /INS 4/29/2019 5/3/2019
George 0001004634 Consumed/INS 4/29/2019 4/29/2019
George 0001006977 Consumed /INS 4/29/2019 5/4/2019
George 0001006978 On Hand / 4/29/2019
George 0001006948 Consumed /INS 4/29/2019 4/30/2019
George 0001003438 Consumed /INS 4/29/2019 4/30/2019
Bookmarks