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

    Listing Maximum values from a Table

    I have a table of 5 departments with the 12 monthly values in that department, What I would like to do is to list the department, maximum value (across all departments) and month that the value appeared
  2. C

    Index & Match Possibly??

    I have a workbook with 1 sheet containing names in col.1 nd scores in another col. A 2nd sheet in the same workbook has the same names in a different order and I want to add the correct score adjacent to the name on the 2nd sheet I am a part-time Excel user@@
  3. C

    Re-ordering a Table

    I have a table with a header (row 1) containing names and each column contains data generated elsewhere in the work book. What I would like to do is create, using formulae, a new version of the table where the order of the header is different and the data under each name is in the same order A...
  4. C

    Matching Values

    I have effectively a 4 column spreadsheet Col A D A E B C Col C A B C D E which is fixed Col D 4 3 0 1 5 I want to populate col B with the matching value from col D i.e. col B should read 1 4 5 3 0 I have tried a combination of INDEX MATCH & OFFSET but got into a...
  5. C

    Product of digits to the left & right of the decimal point

    I have a column of decimal numbers and firstly want the product of the integer & decimal values. e.g. 2.3 produces 6 as does 3.2. I then want the maximum value of the product to identify which rows it occurs in. The problem that I have is that a formula such as =IF(A1=MAX(A1:A12),B1,"") where...
  6. C

    Counting the number of consecutive identical numbers

    I have a table with 18 columns, number of rows is variable. Each cell contains a number from 0 to 5. I would like to know the length of the longest string of the same non zero number. Where the longest strings are identical I would like to see the string for the higher number. Ideally I would...
  7. C

    Cannot find macro to delete it

    I run Excel for Mac 2011. Not sure how I have done it but I have a workbook which when opened says macros present Enable/disable macros. When I go to Tools/Macro/Macros there is nothing to display. How can I remove the enable/disable window?
  8. C

    Dynamic Chart

    New to charting. Data builds up over 15 weeks. 16 Names in column A1 thro A16 and data in columns B thro P. Trying to have a line chart for each of the 16 names. Going round in circles!! Any help would be appreciated Using Excel for Mac 2011
  9. C

    Changing cell from Unlocked to Locked on data entry

    I am an Excel novice and have never written/recorded a macro! I have a protected worksheet with unlocked cells for data entry. When data is entered I would like to automatically change the cell's format to locked. Is this possible?
  10. C

    Excel 2011 Mac - Formula Evaluation

    Does the Formula Evaluation exist for this? My formula auditing only shows buttons for precedents/dependents/error checking/remove arrows. I cannot find how to add evaluation
  11. C

    Condition Format when a specific value in a range of cells

    I have a spreadsheet holding name then 2 ranges of scores (holes 1-9 & 10-18). If the player has scored a 2 in either range I want to highlight their name
  12. C

    Resolving Tied scores

    I am new to Excel and a task I undertook was to use a spreadsheet to score a week long golf tour for 12 players. Scoring is done by points won per hole, i.e. the highest score wins as opposed to a low score being the strokes taken. Ties are resolved by points scored on the last 9 holes, still...
  13. C

    Duplicate values in a list

    I run several competitions and end up with a list of name, score, rank. I use conditional formatting to highlight 1st, 2nd etc in the list and this works for ties. What I would like to do is to display on an other worksheet the highest 3 scores & names. I have used INDEX & MATCH to do this...
Back
Top