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

    Adding together numbers and text

    Hi My file is here: http://dl.dropbox.com/u/13025982/level.xlsx I have a sheet with the following in E3 to J3 5a, 5b, 5a, 5c, 5b (equally it could be any string from 4c to 7a) I am looking to streamline selecting the best numerical representation of these numbers/letters The best I...
  2. I

    Student Data Dashboard

    Hi all I've been trying to create a student data dashboard for the past week. Thanks to some great awesomeness from this forum, I now have a version fit to look at: http://www.glengilchrist.co.uk/wp-content/uploads/2013/01/student-dashboard.xlsm This is part of a post I made on this...
  3. I

    Ranking with IF statement

    Ok folks - I have two columns, BAND and SCORE I want to rank SCORE, BUT BAND has two options (x) or (y). So I want a ranking of SCORE if BAND = x and if BAND = y eg Band Sore x 120 (rank = 2 of the "x") x 111 (rank = 3 of x) y 101 (rank =...
  4. I

    Using named range in AVERAGEIFS formula

    Hi all Happy New Year all or as we say in Wales, Blwyddyn Newydd Dda. I have a 2 named ranges: SCORE which is defined as StudentData!$F$13:$F$300 SEX which is defined as = StudentData!$C$13:$C$300 On a different sheet in the same workbook I want to use this range in an AVERAGEIFS...
Back
Top