for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

1 lurker | 102 watchers

GregP Jan 2019 7:54pm, 15 Jan 2019 110,228 posts	Quote Pin GregP I toyed with mentioning Lisp Brilliant shout with APL. I’d clean forgotten about it. Prolog looks positively mainstream in that company.
Badger Jan 2019 9:29pm, 15 Jan 2019 10,289 posts	Quote Pin Badger Literal lol at Glenners' spectacular get out clause there.
icenutter Jan 2019 9:39am, 21 Jan 2019 173 posts	Quote Pin icenutter How can I find the 'second maximum' from a series of cells? I have a large spreadsheet for calulating the scores for our club champs. Our's works on the principal of WAVA scores. Races are aranged into 3 categories (<10k, >10k and trail/fell/xc). Total score is on the basis of best from each category, plus one more. Its the last thing thats puzzling me. How can I find the fourth highest score from a range of cells?
um Jan 2019 9:50am, 21 Jan 2019 740 posts	Quote Pin um Have you tried the large function?
flanker Jan 2019 12:34pm, 21 Jan 2019 18,087 posts	Quote Pin flanker or a helper column with a CountIf to see how many are greater than the cell's value.
GregP Jan 2019 12:37pm, 21 Jan 2019 110,335 posts	Quote Pin GregP Hold on - I do this on the deathmatch engine. Stand by one
GregP Jan 2019 12:39pm, 21 Jan 2019 110,336 posts	Quote Pin GregP I use =RANK(), which isn't quite the same thing. Um's right though. =LARGE() is what you want.
Curly45 Jan 2019 4:11pm, 21 Jan 2019 3,843 posts	Quote Pin Curly45 Hah I had to study the formation of Lisp for my dissertation... check out this bad boy for the insane: en.wikipedia.org :O
GlennR Jan 2019 4:20pm, 21 Jan 2019 40,363 posts	Quote Pin GlennR I’m sure there’s something I can do with that at work. I was planning to use R to baffle the CFO, but this might be even better.
icenutter Jan 2019 11:06pm, 21 Jan 2019 174 posts	Quote Pin icenutter Cheers for the tips. I’ll report back.