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