Count if

[apgmin]

I need a help with the following:

A1 to h1 will have a default value of either 1 or blank ( this indicates the number of attempts the student makes for the exam )

Now in Cell J1 I want the response "module repeated" if any of the values from A1 to H1 is changed from 1 to 2 or 3 or 4 etc ignoring the blank cells

thanks in advance

 

[apgmin]

=IF(COUNTIF(A1:h1,">1")>0,"MODULES REATTEMPTED","")

Did It, I am becoming addicted to this forum and put a post before trying my best.

Thank you forum members for teaching me excel free of cost