Hello,
I'm looking for some help in creating a formula that auto-populates one table "essentials (pic below)" from another table "details (pic below) if a criteria is met also the formula does not break if rows are added/moved/deleted from "Details" table.
In the following example, I would like to populate the "Essential" table with any cells that are labeled essential in column c of details.
Any help would be greatly appreciated!
Do you need a second table? The easiest way to see only the Essential items is to use a filter on the Details table to show row where column C is "Essential".
If you want to show subtotals of essential and non-esential expenses, use Categories to group and arrange the rows by category, and set the 'category rows' to calculate and show subtotal (total by category.
For the solution you describe, see my post in this thread: Numbers : How to copy entire rows of data matching one criteria.
for formulas and description.
Regards,
Barry
Thank you for your help Berry, I followed the link you provided to get what I needed done.
Auto-populate one table from another table if a criteria is met
