Thread: comparing columns and returning max value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
  
Posts: 390
Default comparing columns and returning max value
In . com,
spake thusly:

I have 4 columns each with 250 rows
looks something like [I fixed your table:]

A B C D
Web URL Correct? URL CSU
? ? ? ?
Yes NA Yes Yes

I want to count the number of of ?'s in the cells in each column,
then compare this number in all columns and return the highest
value.

How about, in Column E:

=COUNTIF(A2:D2,"?")

Drag down, then at bottom of Column E, put:

=MAX(A2:A249)

--
dman
Reply With QuoteReply With Quote