comparing columns and returning max value
 

Hello,

I have 4 columns each with 250 rows

looks something like
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.

No idea how to compare countif's though. or if this is even possible.

Suggestions greatly appreciated :-D

Clive

comparing columns and returning max value
 

hmm

this seems to have worked,

=MAX((COUNTIF(F2:F249,"?")),(COUNTIF(G2:G249,"?")) ,(COUNTIF(H2:H249,"?")),(COUNTIF(I2:I249,"?")),(CO UNTIF(J2:J249,"?")))

but is there an easier way of doing this at all? i.e. with a smaller
formula

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