Placing condition cells like I2 and I3 on a separate sheet can help keep the main sheet tidy. However, Google Sheets doesn’t support direct references to other sheets in conditional formatting rules. Named ranges also won't help here. To solve this riddle, use the INDIRECT function to refe...
Power Tools offers 7 add-ons that remove duplicates and find unique records in your spreadsheets. Whether you're trying to compare columns or sheets, or deduplicate one table, the tools process thousands of records in no time. Choose to find dupes or uniques only, or their 1st occurrences as...
I am using a QUERY in Google Sheets that is counting the number of responses to survey questions. Because it is a branched survey there are blank cells between the responses. Is there a way to query count and exclude any blank cells? Here is my formula: =QUERY(RESPONSES!A1:E111, “Sele...
I am using a QUERY in Google Sheets that is counting the number of responses to survey questions. Because it is a branched survey there are blank cells between the responses. Is there a way to query count and exclude any blank cells? Here is my formula: =QUERY(RESPONSES!A1:E111, “Sele...
Other compared sheets. To process found dupes or uniques on all sheets but the main one: All sheets.To apply the action to all duplicate or unique values across all sheets: main and other compared sheets: ClickCompareto find duplicate or unique values and process them with the chosen action...
Count uniques in Google Sheets with multiple criteria You can go further and count the number of unique products between 200 and 400. Nope, it's not the same as above! :) The above COUNTIFS counts each occurrence of sales between 200 and 400. What I suggest is to also look at the pro...