LinkBack URL
About LinkBacks
Hi,
an attempt using a small fix:
=INDEX($W$8:$W$49,MATCH(MAX(COUNTIFS($W$8:$W$49,$W$8:$W$49&"",$W$8:$W$49,"<>"&""),),COUNTIFS($W$8:$W$49,$W$8:$W$49&"",$W$8:$W$49,"<>"&""),0))
Array entered
Hope it helps
Hi,
an attempt using a small fix:
=INDEX($W$8:$W$49,MATCH(MAX(COUNTIFS($W$8:$W$49,$W$8:$W$49&"",$W$8:$W$49,"<>"&""),),COUNTIFS($W$8:$W$49,$W$8:$W$49&"",$W$8:$W$49,"<>"&""),0))
Array entered
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks