=IF(max(L12:L30)=0,"",if(countif(L12:L30,max(L12:L30))>1,"Varios", index($K$12:$K$30,match(max(L12:L30),L12:L30,0))))
ROW 22 should not be counted in that formula.
Just L12:21 and L23:30
Don't know how to do that.
Thanks in advance for your help
=IF(max(L12:L30)=0,"",if(countif(L12:L30,max(L12:L30))>1,"Varios", index($K$12:$K$30,match(max(L12:L30),L12:L30,0))))
ROW 22 should not be counted in that formula.
Just L12:21 and L23:30
Don't know how to do that.
Thanks in advance for your help
=IF(AND(MAX(L12:L30)=L22,LARGE(L12:L30,2)=0),"",IF(COUNTIF(L12:L30,IF(MAX(L12:L30)=L22,LARGE(L12:L30,2),MAX(L12:L30)))-AND(MAX(L12:L30)=L22,LARGE(L12:L30,2)=L22)>1,"Varios", INDEX($K$12:$K$30,MATCH(IF(MAX(L12:L30)=L22,LARGE(L12:L30,2),MAX(L12:L30)),INDEX((ROW(L12:L30)<>22)*L12:L30,0),0))))Try this![]()
Please Login or Register to view this content.
I think some one come with better formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Wow!
That was fast.
THANKS A LOT!
Works perfectly fine.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks