So I am trying to consolidate data from multiple pivot tables into one output table and can't seem to figure it out
I am looking at a range of data that has both biological and technical replicates - each subject has three slides. 3 subjects per group
The data is cross sectional area of a fiber across a field of view of a microscope.
However since there are variations between samples, not every sample has the same values
I have all the data grouped the same (0-250, 251-500...) but not every field has values in every range
I would like to take the per-subject average and then get the group average but they don't have to be the same table and reckon the method would be the same regardless.
i tried averageif statements and the multiple consolidation thing in the wizard but couldn't get either to work.