Hi everbody!!
I am using this formula, and i get #Value error I believe its because of the "<>" and it wants something else there. Help me out please
=INDEX(Y11:Y504;MATCH(MAX(COUNTIFS(T11:T504;E14;U11:U504;F14;V11:V504;G14;W11:W504;H14;Y11:Y504;"<>"&K14;X11:X504;I14;Y10:Y504;Y11:Y504));COUNTIFS(T11:T504;E14;U11:U504;F14;V11:V504;G14;W11:W504;H14;Y11:Y504;"<>"&K14;X11:X504;I14;Y10:Y504;Y11:Y504);0))
Bookmarks