average by unique text

Greetings! Need a little help and any is appreciated. I have a workbook that basically contains a list of names, places traveled, and dates traveled from last year. So this means that there are duplicate names within the names column. My supervisor would like to take that names column...

I have a sheet where I need to find the average score over time for a category the only scores available are "D", "P", "L" & "M" In order to take anomalies out of the equation I think I need to count all scores and display only the Score that has the highest count, I'm not sure what I will do...

I have a table where I need to find the elements present in different samples. For every sample, the no of iterations is a variable - I can have two rows of sample 1 and 3 rows of sample2 or 5 rows of sample4. the number of columns which are the elements can also be different. I have considered...

I am tracking compliance percentages (2 rows per calendar day). I want a rolled-up matrix of the averaged results for the previous month. I want the average part of the statement to ignore blanks and errors (not column item is required every day) but include zeros (indicates non-compliance). I...

Hello, I am making a lookup table that needs to gather data from from another sheet, the data is as follows (an example) Field API Value Earlie 14 Earlie 15 Earlie 18 Earlie 12 Kitscoty 18 Kitscoty 24...

Hi everyone, Would someone be able to help me in finding a solution to a problem. I have rows of data, which attainment grades are entered in alternate cells across the row, These are entered as text; Ex, G, S, C. I want to create an average cell for each row/student, that will calculate...

There are 3 data points I need to calculate. Number of unique customer names if criteria in another column is met, the average of subtotal by customer if that same subtotal is met and then an average per box. So, what I need to know for following sample data set would be: 1. What is the total...