Return a value if all values in a range are the same.

[Andrrewc]

Hello,

Im needing some help with what I think is a relatively simple formula but just cant crack it.

I have attached a sample sample.xlsx, where everything is explained in a little bit more...

What I need the formula to do is:


Cell F2 to return a value of 1 if every single value is column E = 1, otherwise even if there is one 0 in the column the result is to be 0. Also this needs to be reliant on the EmpCode and Bid Preference being the same.


Many thanks in advance,


Andrew

[Ron Coderre]

Using your sample workbook,
this regular formula, copied down, performs a calculation at each change of EmpCode and returns 1 if all Bid Calculations for that EmpCode = 1

Please Login or Register  to view this content.

Is that something you can work with?

[hemesh]

in sample book in sheet1 in F2 copy paste below and drag down
=IF(SUMPRODUCT(--($A$2:$A$35=A2)*($E$2:$E$35=0))=0,1,0)

[FDibbins]

Hi and welcome to the forum

Not sure what the 2nd file is, but based on the 1st upload (sample.xlsx), use this in F2, copied down...
=COUNTIFS($A$2:$A$35,A2,$E$2:$E$35,"<>1")

[Andrrewc]

Hi All,

Thankyou so much for your help.

This has solved all my problems!