• 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

    Name conflict - (unknown) named ranges have appeared in my spreadsheet!

    Hi all, Have come into a slightly odd issue this morning. I've had an ongoing little project to run some transformations on companies' regular reported financials in order to present them in the way I want to. Today I tried to copy one of my input sheets within a workbook. On doing so I was...
  2. M

    Show cells with no dependents

    Hi all, Does anyone have a nice trick to quickly find cells that don't have any dependents? I'm building a model which is necessarily going to require trawling through financial reports to find the right data to enter. Obviously I want this task to involve the least pain possible, so want...
  3. M

    Lookup top 10 values in a table with conditions

    Hi all, I'm dealing with a large data table, and want to be able to lookup the rows with the top 10 values (in one column) that match a given condition (in a different column). So far I've done it with some intermediate steps, but am hoping that I can cut these out as it's starting to get...
Back
Top