To return HR if HR exists in the array:

=IF(COUNTIF(A:A,"*HR*"),"HR","No HR")


In article ,
Isa wrote:

Thanks for this but it doesn't seem to work.
What I would like is for the function to return HR if HR exists in the array.
Your suggestion does not seem to recognise when HR or Human resource exists
in the array.

Any other suggestions?

Thanks.

"JE McGimpsey" wrote:

One way;

=COUNTIF(A:A,"*HR*") + COUNTIF(A:A,"*Human resource*")