pnuts questions

pnuts answers

• Using SUMPRODUCT with TRANSPOSE
• Using conditional formatting to alternate the formatting of data by category
• (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