1. LARGE()
Used this to find the top 5 of 200 values. Never know you could do this before!
2. SUM(Sheet1:Sheet10!A1)
I vaguely knew you could sum across worksheets before, but cool to rediscover this.
1. LARGE()
Used this to find the top 5 of 200 values. Never know you could do this before!
2. SUM(Sheet1:Sheet10!A1)
I vaguely knew you could sum across worksheets before, but cool to rediscover this.