pnuts questions

pnuts answers

• 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
• Google sheets, if statement multiple conditions
• Is there an Excel function to count occurrences of a certain characters in a cell?
• Build a random row picker that selects a row
• How to find and replace part of a cell with formatted text