summarise columns

hey guys i would like to create a summary of the table into the table below in which when data is entered in the general table the summary table will only show the which have defects such as the poles that are rotten will show up in the table below , also the the pole number from the above...

Hi Community, I´m working on a summary sheet (by date and within a time span (between 2 dates)) and all fine with numeric values, but i can´t figure out how to aproach the columns with cells/columns containing text. For some columns i have to get all disctinct values in one cell for a given...

So I want to summarize data from one sheet to another. I would like this: A B 1 John John 2 Bill 3 Tom 4 Bill Peter 6 Rob 7 8 Tom 9 Peter 10 11 Rob I found some solutions using an IFERROR command which do not...

Hi, I am trying to automise effort calculations for a project by phase (the columns in the spreadsheet hold days per week per resource type). As the phase can vary in time, I've created a header which indicates the phase. I need "something" :) to look up the header to determine which phase and...