pnuts questions

pnuts answers

• (Google sheets) Query and return multiple tables from url inject
• How to replace values less than 10 in several columns with "<10"?
• Counting duplicate data which satisfy conditions and remove data
• Google Sheets: convert string to date
• Lookup a value that matches a key in one column then apply that as a key to return a value from a third column
• COUNTIF not working with string "True" or "False"
• Google Sheets: How do I combine a column of URLs and a column of text into one?
• delete alternate lines in a csv file libreoffice calc
• How to sum the same field twice, but with different sum criteria in pivot tables?
• Use IMPORTXML to import from multiple URLs at one time