| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Display material with usage
Column A contains material name and Column B contains usage. I would like to
choose the name and the total usage of materials that were used. For explanation purposes, Column A Column B Paint 30 Thinner 15 Paint 10 Thinner 5 Caulk 0 Therefore, the table will contain paint = 40 and thinner = 20. Caulk will not be displayed since it had zero usage. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display gridlines at irregular intervals? | Charts and Charting in Excel | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
| Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions | |||
| how to display heading of column corresponding to the cell | Excel Worksheet Functions | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Threaded Mode
