Countifs unique values based on two criteria

All

My first post....

I have a data set that contains various records against unique identifier. I need to be able to return a vaule of "Y" instead of the count - indicating that the unqiue identifer has at least one record with a specified value.

I have tried countifs, countifs & frequency but can't seem to figure it out.

The countifs formula is =COUNTIFS(CASS_Staff_Submission!$D:$D,Sheet2!$D:$D,CASS_Staff_Submission!$K:$K,Sheet2!CH$1) and currently returns a count of 3 - I need to have a "Y" returned..

I have attached a very small example

any thoughts appreciated

Shaz0503

Originally Posted by alansidman

Because you have links in your spreadsheet, I am unable to verify this, but I wrapped your formula in an =If formula
ie. =if((Yourformula) >0,"Y",0)

Alan

...tis always o easy when you know the answer.... thanks heaps

shaz0503