NARAYANK991 - Help please on a formula you gave me

[tarynmahon]

Hi,

I have been using the formula you gave me in my post titled "Count unique values if Multiple Criteria are met ?" but unfortunately it is slowing up my workbook too much for other people to use, I have been given the advice to concatenate my 3 criteria which I can see would probably help but I dont know how to adapt your formula to do this, could you please help? This is what I have so far but it's returning a 0 value;


=SUM(IF(Sep12'!$AN$12:$AN$11952="InceptionADONWeb",1/COUNTIFS(Sep12'!$AN$12:$AN$11952,"InceptionADONWeb",Sep12'!$B$12:$B$11952,Sep12'!$B$12:$B$11952)),0)

 

[Montrey]

Make sure you create that helper column like I said.

 

[Montrey]

Sirjb7 posted a solution in your other thread.

 

[SirJB7]

@Montrey

Hi!

Did I? I don't remember... let me see.

Regards!


EDIT: Checked, but anything found in the related topic. Drinking so early? Ok, it's Friday, I know. Unless the topic were this:

http://chandoo.org/forums/topic/thinking-outside-the-box#post-52452

 

[tarynmahon]

Yes, thats the one that Montrey was referring to, I've responded to your answer in"Thinking outside the box"