Thread: Return Value that exists more than all other values
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Return Value that exists more than all other values
"AdamE" wrote
.. The additional "if" function fixed my problem
as the cells are in fact empty.

I'm puzzled by your assertion
... as the cells are in fact empty.

As stated in my response, the earlier array expression:
=INDEX(1:1,MATCH(MAX(COUNTIF(1:1,1:1)),COUNTIF(1:1 ,1:1),0))
will return correctly, it ignores blank cells

Even Biff himself acknowledges that in his interjection opener:
That formula will ignore *empty* cells ..

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote