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

    how to copy data from an SAP GR55 report when frame/pane is not recognized by script recorder?

    This may be too obscure, but I'm trying to automate running a GR55 report in SAP. Everything works fine, but some of the GR55 reports generate a pane on the left of the SAP screen that can be expanded to show a list of company codes/regions. Clicking on a line in that pane brings up the data...
  2. I

    min from multiple columns if one criteria per row is met

    Hello glorious Chandoovians, I'll set this up with a very simple example: In column A we have an id code. In columns B:K we've got numeric values. I want to find the minimum of those values. That's easy enough. Now let's complicate it by saying that each row has an id code and values...
  3. I

    default copy visible/hidden different on two machines both running excel 2010

    Hello, My colleague recently returned to work here with a different computer and it's acting differently than he is accustomed to. When working with a filter and copying data to paste to another workbook, it is copying rows that are filtered out (hidden) and pasting them into the new book. He...
  4. I

    SAP error handling

    Hello, I have a spreadsheet with a list of document numbers. I have vba code that runs a specific transaction code in SAP, pulls up the first document, then prints the invoice attached to that document, then moves on to the next record. I have a snag when the document doesn't have an invoice...
  5. I

    adding rows conditionally with vba

    Hello wonderful Chandoovians, I have a spreadsheet I send out to ~50 people, many of whom would need special training to filter the results much less get where they need to in a pivot table, so I need to stick to the format they're accustomed to. At least for now, maybe someday I can get them...
  6. I

    upward counting instances of matching multiple criteria

    In a very large data table I have ID numbers in column A, many other columns of data, then at the end a column that flags rows as needing attention. I use this to create a worklist. My column at the end is a simple nested IF statement. If all 3 criteria are met it returns a 1, otherwise it...
  7. I

    excel 2010 displaying 0 as an infinitesimal number in scientific notation

    I'm guessing it's just an Excel oddity, but when I sum numbers I'm sometimes getting ridiculously tiny numbers in scientific notation instead of just getting a 0. For example, copy/paste the below numbers into a blank sheet. If I click on the top one and drag down, the little info area on the...
  8. I

    count of unique values that meet specific criteria

    Hello, I feel like I'm thinking too hard about this and skipping right past the easy answer, but here goes: I have a spreadsheet of roughly 5,000 rows and around 25 columns. One of the columns contains a customer ID, another contains a transaction ID, another contains a geographic region, and...
  9. I

    summing all numbers in a single cell that also contains non-numeric characters

    Hello fine Chandoovians. I'm working on an excel spreadsheet to inventory my Magic:The Gathering cards and I've got what is (for me) a stumper... Say a cell contains this: "{3}{G}//{4}{R}{R}". (Magic players will recognize that as the casting cost of a fuse card). My spreadsheet has a column...
  10. I

    TIME function capped at ~9 hours?

    I have a report in which whole number seconds are converted to a time format. I used to do this by referencing the number of seconds and dividing by 86,400, but then I found the TIME function and started using it instead. A1 = 4000 =time(,,A1) will return 0:00:04, if you have the cell...
  11. I

    referenced table names inside INDEX formula

    I would like to use INDEX & MATCH to return a value from another table, like this: =INDEX(Table1[Trainer],MATCH(A2,Table1[Office],0)) So if you had an office number in A2, this would reference Table1 to find the trainer that uses that office. The kink is that I have a big spreadsheet with...
  12. I

    Finding a total based on multiple percentages

    Trying to find the numbers for total and current when all I have is percentages. example: 20% of X is.. 14% of A 39% of B 245% of C where X, A, B, and C are all positive whole numbers. I can plug in different values for the starting percentage (instead of 20% make it 80%, for example)...
  13. I

    clearing table data and pasting in new- how to keep countif looking at it's row

    Sorry about the clunkiness of the title, was trying to be descriptive of the problem without guessing a solution. I have a data table that is 28 columns and around 20,000 rows. Five of those columns represent currency that can be positive or negative. I want a single column that indicates if...
  14. I

    Creating one list out of three (just the values present on all three lists)

    I have 3 lists of 6 digit numbers. The lists range in length from ~50,000 to about ~80,000. I want to make one list that includes only the 6 digit numbers that are present in all three lists. I don't want to use VBA unless it's a considerable speed advantage as I need to be able to explain...
  15. I

    Top 10 list of names based on sales totals

    Hello, wonderful site here. (hypothetical story that illustrates my dilemma) I've got a list of ~200,000 accounts, handled by ~300 salespeople, and I generate reports weekly to see how much each account has ordered. I put that data into a table and it's easy to sort and filter to find the...
Back
Top