Extract (only non blank cell + highest value) data from multiple similiar tabs

0

Hi guys...Please help me with my workbook (attached)

In the workbook there are four tabs i.e. Cumulative, Data1, Data2, Data3. Tabs Data1, Data2, and Data3 contain information of student performance in each semester.

My question is, how to extract automatically information from Data1, Data2, and Data3 and put it all on Cumulative with these two additional condition:

  • I only want to extract all non BLANK cell of B5:C9 from each Data1, Data2, and Data3
  • If there are subject that retaken, I want to extract data with the highest grade. (as you can see in Data1, Data2, and Data3 there is one subject that always appeared i.e. Biology, this subject was retaken twice with highest grade is B).

I am sorry from my bad english, i hope you can understand my question. Thank you so much!

Answer
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login