• 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

    Autolisting latest changes since the last opening of a file

    Hi everyone, Here is my problem: A file is shared by many people. Each of them need to know when an additions/a change is made to the file. The problem is that this file contains many worksheets... Could a worksheet display a summary of all the latest changes since last opening of the...
  2. M

    Vlookup in Subtotal = Problems...... Address in Subtotal = Problems :(

    Hi, I was trying to do a subtotal that contained a vlookup formula. It didn't work... I realized that subtotal needs a cell reference to function, and not a value... I've tried few things with the Address function, but if I'm right it returns the address as a string content and does not...
  3. M

    Table Headers

    Hey, Is it possible to have vertical tables headers instead of the "default" horizontal ones ? Thx, M.
  4. M

    Linking Tables Dynamically

    Hey folks, Is it possible to dynamically link a table to the content of another table? Here is what I have done: -Insert a table in A1:A3 -Insert a second table in C1:C3 If do this: E2=Table1[Column1] Then it copies in e table 2 the content of the table 1 That's already a really...
  5. M

    Dynamic Hide

    Hi everyone, I'm here for my daily dose of help :) This is what I would like to do : If a cell of a specific row return a certain result Then Hide all the following columns For instance: If a cell in row 1 returns 1000 (lets in Z1) Then Hide all the following columns (AA, AB, AC...
  6. M

    Outline Manually Upward

    Hi ! When you manually create an outline to group data, it groups rows "downwardly" Lets say you want to group row 2,3,4. If you select those and group them, it will do so on row 5. I don't like it this way... :( Do you know a way that allow to group "upwardly", i.e that would group...
  7. M

    Consolidation ?

    Hi everyone, Can somebody please tell me how to consolidate data from several worksheets into one (income statements for several years) into one excel sheet examining the trend by department? They are not of the same format necessarily, I will need the formula to lookup the first column...
  8. M

    Autofill horizontally - Leaving empy cells at regular intervals

    Hi everyone, This is my first post here. What an awesome website ! I am sure that what I want is already somewhere in the forum. But I don't really know how "phrase" what I am searching for... So lets go to the point : I have in the following cells : C1, D1, E1, F1 etc... What I want...
Back
Top