1. W

    VBA- finding alpha numeric numbers in another sheet

    I have a macro that searches for numbers in another sheet and then copies the row it finds it in to sheet 1. the problem is that some of the search criteria is alpha numeric. i.e 227A, JD190T, etc. code Sub copyit() Dim wsSearch As Worksheet, wsResult As Worksheet Dim Found As...
  2. G

    NPV works well with excel???

    Hi Somebody told me that the NPV formula used by Excel doesn´t calculate the value correctely. Is this true??? I´m trying to calculate the NPV for this cash flow, Investment: -10.000 1st period 1.000 2nd period 3.000 3rd period 3.500 4th period 4.500 5th period 10.000 Rate: 2%...

Some videos you may like

This Week's Hot Topics