pnuts questions

pnuts answers

• 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()
• Excel - list in two columns each unique-pair from two source columns in excel
• Transpose column on one sheet to row on another, with linking
• Cell showing Date but not Time