Search:

Type: Posts; User: krokodilizm; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    630

    Re: vlookup with offset rows

    Hey thanks. It works but there are two problems with this, hope you can help:

    1. The formula returns error when the term "John" is used. It returns the correct number when I use the cell reference...
  2. Replies
    2
    Views
    630

    vlookup with offset rows

    I have the below problem analyzing a bank movement

    https://i.imgur.com/mDKq9gZ.png

    I want to filter out all JOHN payments but as you can see the amount is out of sync with the term 'john' by 6...
  3. VBA to create invoices using external inputs

    I have an Excel template for invoicing manually and I'd like to automate the key variables, i.e. date, reference, amount and description.
    I have these variables in a separate Excel file
    <tbody>...
  4. Re: Recalculate formula using incremental changes

    Geez, it's done using the Data Table function. I knew that I knew this!
    Thanks anyone reading this...
  5. Recalculate formula using incremental changes

    I'd really google this if I knew how to phrase it properly but it keeps coming up with irrelevant results. Here is my problem:

    A1=25,000
    A2= a complex chain of formulas that depend on the entries...
  6. Replies
    13
    Views
    304

    Re: Use wildcard in VBA

    He :) Note it is grammatically wrong to say he/she and then say they. The correct sentence is "Well glad he/she received the help he/she needed". Just saying.
    The tendency these days is to use "she"...
  7. Replies
    13
    Views
    304

    Re: Use wildcard in VBA

    I definitely will! Thanks.
  8. Replies
    13
    Views
    304

    Re: Use wildcard in VBA

    Well spotted. That was the original idea, to keep the 4 characters on the right hand side.
    I am adding all these codes to a library of text files with detailed file names for casual use. I will try...
  9. Replies
    13
    Views
    304

    Re: Use wildcard in VBA

    Wow thanks. Really appreciate your time. The code runs smoothly.
    I am new to VBA but I can somewhat deduce what is going on when I see a code. It's the commands and the syntax that I can't derive...
  10. Replies
    13
    Views
    304

    Re: Use wildcard in VBA

    Column H. Given the VBA code it is easy to tweak the references, no? So I thought it doesn't matter which row/column you reference in the template.
  11. Replies
    13
    Views
    304

    Use wildcard in VBA

    I have a column of invoice numbers that are not consistent. Some are 4 digits, some are 6 digits (they include the year in front, e.g. 16xxxx). The Find and Replace function is limited. How can I...
  12. Replies
    0
    Views
    209

    VBA to generate statement of account

    Has anyone written a macro to generate a custom statement of account from a list of data?
    For instance out of 100 entries John Smith made 10 payments on different dates and I would like to integrate...
  13. Re: Mergers & Acquisitions Case (2013 Round 2)

    With a bit of lateness, why don't you post the problem here to see what it is about?
  14. Replies
    13
    Views
    469

    Re: IF with multiple arguments

    Off to learn how to fish now that I ate one...
  15. Replies
    13
    Views
    469

    Re: IF with multiple arguments

    Actually its all tip-top! Failed to notice this applies to 9th row (E9) and pasted instead on the first row.
    :bow:
  16. Replies
    13
    Views
    469

    Re: IF with multiple arguments

    Thanks Alan!
    Though the result is not correct (must tweak some numbers) the syntax is error free.
    Thanks guys for the time and effort invested. This board looks cool and highly responsive. Keep up...
  17. Replies
    13
    Views
    469

    Re: IF with multiple arguments

    OK Joe :)
    Give me 12 hours to digest this. Will scrutinize this tomorrow.
    Thanks.
  18. Replies
    13
    Views
    469

    Re: IF with multiple arguments

    So here I added Joey's and Alan's ideas, but still Excel output = too many arguments.
    ...
  19. Replies
    13
    Views
    469

    Re: IF with multiple arguments

    So there is definitely an IF missing :) Let me see...
  20. Replies
    13
    Views
    469

    IF with multiple arguments

    Guys can someone compare the below two and tell me where is the syntax error in 2nd formula? Formula 1 works fine (I copied it from a thread and changed inputs). In formula 2 I want to expand formula...
Results 1 to 20 of 20