pnuts questions

pnuts answers

• Creating chart of only certain rows
• Union of multiple columns as one column
• Error while calculating maximum value in a series
• Convert multiple value columns into new key, value pairs
• 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