• 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. A

    Sumif with dinamic criteria

    Hallo, I have a budget, with sheets for every department and a consolidated sheet. On a summary sheet, I want to be able to select a department and a month and the relevant financial information will be visible. My line items (financial accounts) are in column C, I have a drop down list with...
  2. A

    Dependent Drop down list in seperate worksheets

    Hi, I am compiling dependent drop down list, where I want the information to be on a seperate sheet than the final drop down list. My information is as follows, on Worksheet called "Information": Gender (Male/Female/Team); [formula to select: Data Validation/=Gender] column A, Belt Colour...
  3. A

    Unique random numbers

    I require unique random numbers to be generated per the number of contestants on drawsheets. The array formula I have is eg. for 20 competitors =LARGE(ROW($1:$20)*NOT(COUNTIF($B$2:B2,ROW($1:$20))),RANDBETWEEN(1,21-ROW(A1))). For 10 competitors, I have to manually change the ROW formula to ROW...
  4. A

    SumProduct with multi conditions

    I have a budget, with consultants’ names, wether or not they are inhouse (yes/no), then 12 columns for time spend in every month. In a Data sheet (with among other information) their hourly rate, which varies per month. I need to calculate in sheet 1, as a total “below” the sum of hours per...
Back
Top