Assume a worksheet which has scores (1-10) on four future dates on nine questions. Each row represents responses for one question. Likewise there are 20 respondents i.e. 20 worksheets which have the same structure. One may want to summarise data from all 20 worksheets into one worksheet. The question and solution are more clearly explained in the attached […]
Read More →
Summarise data from multiple sheets with one condition – PartII
{ 2 Comments }