Determine average weight per day per person

[ReggaeRoy]

Hi All
Hoping someone can get me started with a solution to the following problem, THANKS in advance.

I have a column (35 rows) with the date sometimes 1 or 2 the same day up to 9. The next column is a Name (2 sometimes 3), Next a docket#, Weight, Type, another docket #.
I am trying to get an average weight per day per person, for the sheet. To complicate things when the rows are filled I start a new sheet and carryover some info.
I am stuck on the required formula to read the dates, see if they are the same then do the rest.

Thanks for looking.

[keme]

A pivot table is a common tool to make this kind of summary. Note that typos (e.g. leading trailing spaces) may disturb the results of pivot tables, as with formulas. With a pivot table this is more obvious as you will usually get double entries, where a formula will just dismiss the entries where there is a typo.

One thing you need to be aware of: a pivot table is not "live" like a formula is. When data change, you must right click to find the option in the context menu to refresh the table.

I also enabled "drilldown" so you can double click any intermediate/final result inside the pivot to get a new sheet with the source data for that result.

[ReggaeRoy]

Thanks.
I'll bone up on pivot tables and try it out.
Bah, head exploded forgot what I was trying to find out.

I'll keep at it.

Thanks Again for your advice.