bananapancakes
New Member
- Joined
- Sep 18, 2015
- Messages
- 2
The basic setup is that I have an Excel file with multiple sheets, each of these sheets has a data table. These data tables (lets singular-ize them and call it Table_Data for the example) list a Date (numeric), Description (text), Category (text), Value (numeric), and a other pieces of information. What I want to do is create an auto-populating summary table (lets call it Table_Summary) in another sheet with the following conditional logic applied:
if Table_Data[Category] = Category_X **Note that this category will be pre-chosen text for Table_Summary**
then auto-populate Table_Summary with Table_Data[Date, Description, and Value] **Note I do not want the entire row of Table_Data, just these three selected pieces of info in their own separate columns**
Do you have any guidance on which functions to use for this?
if Table_Data[Category] = Category_X **Note that this category will be pre-chosen text for Table_Summary**
then auto-populate Table_Summary with Table_Data[Date, Description, and Value] **Note I do not want the entire row of Table_Data, just these three selected pieces of info in their own separate columns**
Do you have any guidance on which functions to use for this?
