pnuts questions

pnuts answers

• How to calculate ALL modes in a Google Sheets?
• Google Sheets - Ignore empty cells (JOIN & QUERY)
• OR in custom conditional formatting formula
• OpenOffice Calc: Counting unique strings in cell range
• IF statement using TIME
• Calculate the standard deviation from a binned list
• Conditional Formatting with increasing colors
• Adding an Excel Data bar to one cell that is entirely based on the value of another cell
• How to select all columns in a row?
• How to find groups of individuals who attended multiple events together?