Hi, thanks for looking. I am learning to use tables instead of ranges. I noticed that when I inserted a formula it immediately copied down the column to the end. I thought that was neat. So I filtered it and modified the formula for the filtered records and it did it again including the items I filtered out. I built this workbook as table based to learn about it since I ever did was name ranges. In this case the column is for a minimum order amt. I have tools, janitorial supplies, office supplies, equipment, and accessories. Each uses a different formula to determine the minimum based on if we can track usage and other criteria. Am I going to need a separate column for each category to get it's own formula? Is what I am doing not a good fit for tables?
I appreciate y'all looking and really appreciate all the education available here. Thank you.
I appreciate y'all looking and really appreciate all the education available here. Thank you.