5 goggle individual google sheets are there .. One sheet contain marketing students attendance one sheet contain general paper all student attendance, other 3 sheet contain HR paper, finance paper and system paper attendance. Now I want to compile the overall attendance. Problems are there only. Because few students have marketing with HR few have marketing with finance or finance with system etc. Means there are m:n combination. Now if any one help me how I can solve the problem
Solved by E. E. in 18 mins