I need urgent help in google sheets combining the two sheets by user_id and calculating the pass percentage of a clear result in both checks. Questions: 1. How do I combine the sheets by user_id 2. How do I calculate the clear % for check 1? 3. How do I calculate the clear % of check 2? 4. How do I calculate the clear % of both the checks?
Solved by E. E. in 16 mins