Uniform Issuance Analysis.xls
I'm trying to make sense of the uniform database at my company (it's a Japanese owned company, and they just love to wear uniforms). I want compile and analysis the latest issued uniform sizes and types to assist me in planning for new procurement quantity and stock-in-hand planning. I've managed to return the latest issue data at row N to Q. However, I want the formula to exclude the "Maternity" data and select the next non-"Maternity" latest data. I've tried to use the combination of IF and MAX function and insert it into the "Type" row, but to no avail. I would appreciate it very much is you guys could help me sort this problem out.
Formula for type row
=OFFSET(INDIRECT(CELL("address",INDEX(R6:AO6,MATCH(MAX(R6,V6,Z6,AD6,AH6,AL6),R6:AO6,0)))), 0, 1, 1, 1)
Formula for date issued
=MAX(R6,V6,Z6,AD6,AH6,AL6)
Bookmarks