Search columns by a specific text and use countif

[Infix]

Hello,

I am looking a solution for this:

1. I need to define a specific text in row (not each column), for example: "STAT"
2. Use function countif on value below (Cpk) - row Nr 24
3. Do some popup window where will be a result "Values Cpk > 1,33 : NUMBER , Values Cpk < 1,33 : NUMBER"

I need some VBA code. Can u help me?

 

[Fluff]

Duplicate to: Search columns by a specific text and use countif

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.