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

    Dynamic array allocation

    Brilliant, thanks! I will have a look once I get home today - would be great to have those instructions for the Personal.xlsb file - I never heard of it before!
  2. M

    Dynamic array allocation

    Microsoft Excel for office 365 MSO (16.0.12026.20344) 64-bit
  3. M

    Dynamic array allocation

    So I want to be able to type in a person's name in a cell and the result should be the names of the people that person has played against and the match points.
  4. M

    Dynamic array allocation

    I don't make the excel sheet. I just want to know how to consolidate the results in the tables please. Thanks.
  5. M

    Dynamic array allocation

    Hi - I play chess for the Bristol league and unfortunately the league still use a rudimentary excel sheet to report progress. 1. The sheet can be downloaded from https://www.chessit.co.uk/ - it's called Update.xls 2. If you go to the tab saying "Individual results" you will see that each match...
  6. M

    Dynamically create array names

    Thanks for the reply. I will check it out. What I also found out was that there is an automatic naming function in excel wherein Excel creates named arrays on it's own. I think I can use that too but the results will need some processing into a particular format.
  7. M

    Dynamically create array names

    Thanks for the reply. Brilliant. I can't seem to understand how some of the names have been defined though? What does #REF mean in the name definition? Also, how did you manage to re-create the tables in the second sheet just by referring to two arrays. I can't replicate the effect!
  8. M

    Dynamically create array names

    I play Chess for the Bristol League. Now, the results are reported in a really weird way - see "Individual Results" sheet in the attached workbook. I want to automatically create array names for each table on this sheet so that I can reference these tables later in formulas. Any help?!
  9. M

    NEW TYPE OF PIE CHART!!

    I stumbled upon this idea of a new kind of pie chart Lets say we have 4 categories of expenses: Home, Children, Entertainment, College Within these categories we have expenses as follows Home -> Rent, Furniture, Supplies, Groceries Children -> Books, Uniforms, Stationery...
  10. M

    Manual entries in a dynamic table.

    I have created a dynamic table. The inputs are Start Date, End Date each in different cells. Then I calculate the number of 30-day intervals between the two dates. I have managed to create a dynamic table that spits out two columns depending on the number of intervals -> namely Serial...
Back
Top