• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. O

    VLookup with Multiple Values and Wild Card

    Hi, I am able to do VLookup with Multiple Values, but unable to solve with wild card. Example below: SUBJ ACCT OBJECTIVE Opening Balance APR MAY JUN ‭351800-CAPITAL GRANTS UNAPPLIED‬ ‭8300-CLGX_GG_CGUZ_SAFER & STRONGER BUILDINGS ‭999999-DEFAULT‬ -2,457.23 3,456.87 2,786.19 4,001.23...
  2. O

    How to use Sumif with multiple Rows

    Hi John, Thanks it works perfectly. Cheers. @Rahul - Thanks for you help.
  3. O

    How to use Sumif with multiple Rows

    Hi Rahul, Can't it be done without using total column, just by using sumif. The point is don't want to manipulate the source report in any way. Thanks.
  4. O

    How to use Sumif with multiple Rows

    Hi, I need help with sumif formula using wildcard criteria, with multiple rows. In the below example, I wish to calculate D01.H231548.365897.2356"*" from APR-OCT Hope I am clear in what I am asking. Code Opening Balance APR MAY JUN JUL AUG SEP OCT...
  5. O

    Help needed with SUMPRODUCT/SUMIF across multiple columns with criteria

    Hi Hui, Can I use the same formula with wildcard. Regards,
  6. O

    Pivot Table

    Hi, Help!!! I need a pivot table with Row/Value and than Row/Value again. I am not sure if I have explained this properly, please see a sample attached. Thanks in advance Owais Ahmed
  7. O

    how to create a dropdown list with number of checkboxes

    Hi, I have prepared a graph with checkboxes. Came very nice. Arranging all the checkboxes under the graph is not looking neat and tidy. I have too many checkboxes which I want to place them in a dropdown list. Is this possible. Thanks.
  8. O

    Using two matching criteria in a vlookup

    Hi, I have a salary spreadsheet with employee no, Cost Centres, name and various salary costs, and total salary. I am using a pivot table to sum up all the cost centre costs in another spreadsheet. I then create spreadsheet for each cost centre, showing employee no, cost centre, name, and...
  9. O

    Removing part of a name

    Thanks Excel Ninja, really helpful.
  10. O

    Removing part of a name

    Hi Chandoo, I want to get rid of Title in a name, which is between First name and initial, something like this: Abrams, Coun K. I just want to get rid of "Coun" to get the result as Abrams, K. Thanks in advance. O Ahmed
  11. O

    Adding amounts at date intervals

    Hi, I have a bank statement and want to total the entries, debits and credits in separate columns, for each day. I am not good at macros, so please help with simple tricks. Thanks in advance.
Back
Top