2022-11-20 01:25 UTC
@hogesonline This might be a rubbish way to do it, but if you want the max and second max in two different cells, the max obviously can be obtained with MAX(), and the second max with something like INDEX(SORT(A1:A8),7,1); this assumes a list of 8 cells. Not sure if this would help in what you are looking to do though.
Replies (0)
No replies.