comparing columns and returning max value

Q

quetzalc0atl

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
 
Q

quetzalc0atl

hmm

this seems to have worked,

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

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

Dallman Ross

I have 4 columns each with 250 rows
looks something like [I fixed your table:]
Click to expand...
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.
Click to expand...

How about, in Column E:

=COUNTIF(A2:D2,"?")

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

=MAX(A2:A249)
 
Top