• 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, 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...
  3. 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
  4. 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.
  5. 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...
  6. 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
  7. 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