| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Building a table with formulas rather than a macro
In column A, I have a list of names (Abbott, Addas, Amling, Benner...)
In column B, I have the sector they are in (Media, HealthCare, Media, Telecom...) In column C, I have their sales (24.5, 26.4, 30.0, 12.1...) On another sheet, when I select a sector (say Media, in cell D1), I want to be able to recalculate and show Name (Col A) and Sales (Col B), just for the Media bankers Is this possible? Also, Media might have 8 bankers, but Technology might have 4 bankers, so the formula would need to be able to handle that variance too. Thanks in advance for any help Daniel Bonallack |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| table | Excel Discussion (Misc queries) | |||
| table | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions | |||
| Macro for formulas | Excel Worksheet Functions | |||
Threaded Mode
