comparing columns and returning max value

  • Thread starter Thread starter quetzalc0atl
  • Start date Start date
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
 
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare 2 columns of numbers and place the matched numbers in a 3r 5
Compare Cells of Text and Return Highest Value based on a Customiz 1
comparing two columns 2
If cell empty delete row 1
Return MAX value from column B and Name from column A 2
Comparing two columns and returning value from another column 1
Writing a macro to compare columns and return a value 1
Return duplicate max values in same cell 2

Back
Top