pnuts questions

pnuts answers

• Format times to display with 'AM/PM'
• Count of cells containing specific text
• How to select rows in google sheets by condition
• Copy cell from on sheet to another, if other cell in row matches values
• I want to give an ID to each row. How do I do this with a formula?
• 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