pnuts questions

pnuts answers

• I have been asked this in interview . Is LinkedHashSet or LinkedList faster?
• Additional instances (IF OR AND)
• How to use VLOOKUP result as COUNTIF criteria
• 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