I need some Excel Formulas inputted into the attached sheet. I just can't figure it out.
There are 4 tabs on the bottom. Hardware,un-serialized, serialized and summary.
When a quantity is entered in the first 3 tabs then we need it to add to the summary page. With the correct quantity beside the product. The hard part is that we don't want the quantities that are left blank to show up on the summary page.
When we input a number beside the serialized item for quantity. Then we want it to summarize as well, but instead of putting the quantity beside the product ,we want it to fill in that many product spaces.
For example: If I type a 5 beside J1 Tria then on the summary page , it will have 5 product lines that say J1 Tria. This will allow us to enter 5 different serial numbers beside them.
Less than 30 hrs/week
Less than 1 month< 1 monthProject LengthDuration
I am looking for freelancers with the lowest rates