I'm using the countif function and I need some help.
I have several rows of data but I don't want to use them all.
I have a problem though, because I can't arrange the data so
the rows I want are all together.
Lets say my data starts in row 1 and ends in row 6,
I only want rows 2, 4, & 6. I have tried holding ctrl and selecting
just those rows, but it separates the ranges with commas and I think that is
what is messing up the function. COUNTIF separates its data from the
criteria using a comma. I tried placing ( ) around my data but that didn't
work either.
Can someone help please.
The function I am using is the array function:
=MAX(IF(COUNTIF(Rannge, Range) 0, Range))