Work computer wont let me do a mini sheet. I am trying to figure out how to take the size in filter size with the quantity applicable, multiply it by the frequency column, then have a list of each individual filter size.
so 20x25x1 qty of 1 times 2 equals 2 then add up the rest to have a total of 4 20x25x1. But do that for all columns and rows in a massive spreadsheet.
so 20x25x1 qty of 1 times 2 equals 2 then add up the rest to have a total of 4 20x25x1. But do that for all columns and rows in a massive spreadsheet.
| QTY | FILTER SIZE 1 | QTY | FILTER SIZE 2 | QTY | FILTER SIZE 3 | QTY | FILTER SIZE 4 | FREQ |
| washable | 2 | |||||||
| 1 | 20 X 25 X 1 | 2 | ||||||
| 1 | 20 X 25 X 1 | 2 | ||||||
| 1 | 16 X 16 X 1 | 2 | ||||||
| 1 | 16 X 16 X 1 | 2 | ||||||
| 1 | 16 X 16 X 1 | 2 | ||||||
| 1 | 16 X 16 X 1 | 2 | ||||||
| 1 | 16 X 16 X 1 | 2 | ||||||
| 1 | 16 X 16 X 1 | 2 | ||||||
| 1 | 16 X 16 X 1 | 2 | ||||||
| 1 | 16 X 16 X 1 | 2 | ||||||
| 1 | 16 X 20 X 1 | 2 | ||||||
| 1 | 8-1/4 X 25-3/4 X 1 | 2 | ||||||
| 1 | 16 X 20 X 1 | 1 | 16 X 16 X 1 | 2 |
