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

    Displaying arguements in a UDF

    Thanks to all the help from Chandoo's articles and everyone's advice here, I've completed my first user-defined function. It has 10 arguements, which must be selected in the correct order. When I select the function, I want the arguements to appear like so: =UDF(arg1, arg2, arg3, ...) Any...
  2. S

    Using Excel 2007 Tables in Advanced Filter

    Yet another question for the gang. I'm using Chandoo's excellent Split an Excel File into Many Tutorial - http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/ - to divide a large report by division. I ran into a small problem which may be an Excel 2007 quirk: I have my data...
  3. S

    Keeping Pivot Tables Column Headers

    All, In my excel challenge, I have a report that produces multiple pivot tables. However, because of a reorg, I need to produce multiple versions of the same report for each new division. These pivot tables have Column Headings like "Word, Excel, PowerPoint, Acess, OneNote, Bob" But not...
  4. S

    SUMPRODUCT with Wildcards

    I'm working on a revision of a report my team runs every week. I've decided to take the plunge into SUMPRODUCT after reading about it here. I have many different columns to look up, but basically I'm worried about two: The date of a particular action and the organization that the action...
  5. S

    Weird VLOOKUP quirk?

    Today I was using VLOOKUP against a series of my organizations divisions. The last choice was "All" (no quotes) but the formula returned a 0 response. If I changed it to anything not beginning with All, the lookup worked perfectly. Has anyone else run into this?
  6. S

    VBA Help: How to link multiple control cells to multiple page filters?

    I have a report where I'm breaking down by one large category and then by a sub category. So for example, the large category would be Car Makers with selections Honda, Toyota and Ford. And the sub category would be models under the major catgories (Honda would display Civic, Accord, Odyssey...
  7. S

    Linking Excel to Sharepoint

    Hello all, I'm back with another question: I have a list of about 37,000 codes (think similar to chart of accounts) that I have to include in EVERY report I do, so management can drill down by major account to minor accounts. It's my fault, really, I've got them used to having data at their...
  8. S

    Using Excel to track order status

    All, I run a report where I track the progress of various orders. Our tracking software (homegrown) records dates for each milestone such as when a order comes in, when it is assigned, etc. I want to use these dates to derive the order status. Right now, I used a series of long and...
Back
Top