Recent content by sharyn

SOLVED :) =IFERROR(ROWS(UNIQUE(FILTER(Report!$F$2:$F$960,(Report!$F$2:$F$960<>"")*(Report!$B$2:$B$960=B23)))), 0) Hi, I have a table with a number of different locations (column a). I'm trying to find a formula which will tell me how many different people have registered against each location...

Thank you so much. There seems to be a bit of a change to what I snipped, there is one point in time that the change is from pre to post. The pre- post info is also in a different sheet to the yes/no- will I need to change this to get this to work?

I can't attach a workbook, but hopefully this snip will work: What I need to calculate, is whether there is a yes for each scale, for the 'pre' days only. This window of 'pre' days is variable. Is this clearer? Thank you for your help! Greatly appreciated!

That's perfect, thank you!

Hi, Q1: example table below, what I need to do is count the number of 'yes' total, except the first section, which is yes if any (so max 1). Red yes Blue yes Green no Banana no Apple no Orange yes triangle yes...

Thank you! That's working!

Hi, I haven't been able to find a solution for this issue. I have a list of options (red, green, blue, black) in a column. I want to be able to give a yes answer to 'does the range contain red and green'). I've tried IF(AND(ISNUMBER(SEARCH..... but if I change the values in the list, it...