Search results

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...

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...

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...