ExcelBanter - mulitple concatenate conditions

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - mulitple concatenate conditions (https://www.excelbanter.com/new-users-excel/152918-mulitple-concatenate-conditions.html)

Alchemist

mulitple concatenate conditions

hiya.
Can you use concatenate with more than one if criteria?
I'm using this currently:
=CONCATENATE((COUNTIF(D5:D91,"*DVD*"))," = DVD")

How could I use the above to search more than one criteria such as "DVD" and
"VCR" instead of only "DVD"? Concatenate works fine except I cannot search on
multiple terms. Can be done with another function maybe?

CLR

mulitple concatenate conditions

Maybe..........

=CONCATENATE((COUNTIF(D5:D91,"*DVD*")+COUNTIF(D5:D 91,"*VCR*"))," = DVD")

Vaya con Dios,
Chuck, CABGx3

"Alchemist" wrote:

hiya.
Can you use concatenate with more than one if criteria?
I'm using this currently:
=CONCATENATE((COUNTIF(D5:D91,"*DVD*"))," = DVD")

How could I use the above to search more than one criteria such as "DVD" and
"VCR" instead of only "DVD"? Concatenate works fine except I cannot search on
multiple terms. Can be done with another function maybe?

Sean Timmons

mulitple concatenate conditions

=CONCATENATE((COUNTIF(D5:D91,"*DVD*")+COUNTIF(D5:D 91,"*VCR*"))," = DVD and
VCR")

Will add the count of VCR and the count of DVD.

"Alchemist" wrote:

hiya.
Can you use concatenate with more than one if criteria?
I'm using this currently:
=CONCATENATE((COUNTIF(D5:D91,"*DVD*"))," = DVD")

How could I use the above to search more than one criteria such as "DVD" and
"VCR" instead of only "DVD"? Concatenate works fine except I cannot search on
multiple terms. Can be done with another function maybe?

All times are GMT +1. The time now is 11:28 PM.