• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countif /vlookup

C

chethan

New Member
I have attached a sample spreadsheet which contains values like
csrini/Zircon Free csrini PAC PAC PAC PAC PAC PAC PAC PILLAR PILLAR

I want to exclude the certain text such as (PAC PDU and Pillar ). I want to use a dynamic COUNTIF or any other formula so that when I want to add to the exclusions I can do it without much changes to the formula.

Is it possible to add a range? Currently I am using the formula below.

=COUNTIFS(B6:M6,"<>*PAC*",B6:M6,"<>*PDU*",B6:M6,"<>*PILLAR*",B6:M6,"<>*Free*")


Thanks
 

Attachments

Chethan

Firstly, Welcome to the Chandoo.org Forums

What do you mean by "Add a range"?

What are you trying to do?
 
Hi Hui,

Thanks for your response,

By "Add a range" means I want to list out the exclusions in another sheet and the formula should exclude those text and only count the rest of the cells.

Note: The cells i want to count included blank cells as well as merged cells.

hope this explains what I was trying to do.

Thanks
Chethan
 
Hi Hui,

Thanks for your response,

By "Add a range" means I want to list out the exclusions in another sheet and the formula should exclude those text and only count the rest of the cells.

Note: The cells i want to count included blank cells as well as merged cells.

hope this explains what I was trying to do.

Thanks
Chethan
 
Hi Chethan ,

Off-hand I cannot say ; try it and see.

As far as I can see , a merged area can contain only one item of data , so it should work.

Narayan
 
You must log in or register to reply here.
Back
Top