Unknown amount of participants (1-50) will give values 1-5 in two polls (kysely), from poll A we need only values 1-4.
In Sheet2 people make same poll later.
in Sheet3 it subtracts Sheet2 results from Sheet1.
Then it should pick up how many gave >=1 in poll b than poll a, this works fine. In my example 2.
Then it should pick up how many gave <1 in poll b than poll a, but excludes if somebody gave 5 in poll a. In my example 28, should be 6.
It wonīt exclude fives from sheet1. I tried many different formulas, but couldnīt get it working.
Is there easy way to get rid of those extra zeros? i used paste link in 2 first sheets and was able to hide zeros from Excel options, but i need empty cells B2:B51 in Sheet3.
Bookmarks