pnuts questions

pnuts answers

• Getting the Nth instance of an element
• Formula to get the month of the last value
• 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