pnuts questions

pnuts answers

• How to choose the delimiter for splitting text into columns?
• Conditional Formatting based on values in a Table gives 'name range' error
• How to get peak price of a stock after a particular date in Google Spreadsheet?
• Formula to reference data from a PivotTable
• Code isn't calculating decimal places
• Using ImportXML to pull URL and anchor of link containing the string
• I can't understand what XlSaveAsAccessMode is, can someone explain it?
• Function to split text in cell and create column
• COUNTIF function if day of week is Tuesday
• Round values before SUM()