pnuts questions

pnuts answers

• Google sheets - conditional formatting from other sheet
• OR logic and CONTAINS in a query in Google Sheets
• 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)