Not sure if this is doable, please see attached for a sample of the data.
What I am looking for is an automated way to create a list of items based on the following rules:
For Column J (Short Itm)containing more that one item number
where Column G (QOH) is not null and > 0,
Column H (Max Capacity) not null
Column C = S1
then take the AVG of Column G / AVG Column H.
See "What im looking for" sheet for an example of the output in the borders.
Any help is greatly appreciated, thank you so much,
Jon
sample Item.xlsx
Bookmarks