Hi
I am trying to recreate a table with multiple columns based on one criteria. I want all of the same information in the table not just the sum of so I am not sure pivot table is the answer and IF formula seems like a long winded way ? Surely there is a simple way of doing this!
For example I want to have a table that shows all jobs that are unpaid. So this needs to include all the information in 6 or 7 columns in 5 different sheets.
I am trying to recreate a table with multiple columns based on one criteria. I want all of the same information in the table not just the sum of so I am not sure pivot table is the answer and IF formula seems like a long winded way ? Surely there is a simple way of doing this!
For example I want to have a table that shows all jobs that are unpaid. So this needs to include all the information in 6 or 7 columns in 5 different sheets.