pnuts questions

pnuts answers

• VLOOKUP is returning blank as 1/0/1990, rather than nothing visible
• 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