Hi.
So I've made a post that is a little similar to this post, but the question is another.
Ok so I got this formula
=IF(D2=MAX(D3:D22;10.
Is there any way I can get it to give it 9 if it is the second highest(MAX).
Someway like this
=IF(D2=MAX(D3:D22;10.+IF=IF(D2=(second)MAX(D3:D22;9.
Bookmarks