Rajiv was skeptical. "This looks like homework. How does this help me?"
Create a new column called "Status." Use an IF formula to automatically flag low stock items. =IF(G2<5, "REORDER", "OK") In this example, if the quantity drops below 5, the cell will read "REORDER." automobile spare parts list in excel
The Original Equipment Manufacturer part number for exact matching. Rajiv was skeptical
If you don't want to type SKUs manually, use this trick. Assuming Category is Column B and Sub-Category is Column C: =LEFT(B2,3) & "-" & LEFT(C2,3) & "-" & TEXT(ROW(A1),"000") This turns "Brakes / Pads" into BRA-PAD-001 . "OK") In this example
And it all started with a blank Excel grid, a curious niece, and a simple list of spare parts.