I need VBA to compare values in column B and column A in worksheet 1 to values in column B and column A in worksheet 2. If the same values are present in both columns of both worksheets, copy the full rows into worksheet 3. If values in both columns are present in worksheet 1 but not in worksheet 2, copy the full rows into worksheet 4. If values in both columns are present in worksheet 2 but not in worksheet 1, copy the full rows into worksheet 5.
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.