Search results

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

Amazing, as per usual. You guys are the best.

I forgot to mention that there can be empty cells in B:K, if that matters. I don't want it to return a zero because it matched an empty cell.

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

Using ctrl-g to select visible cells only works fine for him, and that's what he's currently doing as a workaround until we can sort out why the default behavior is so odd. And SirJB7, the file he's using doesn't matter. Any file shows this behavior. EDIT: the thing that's nagging at my brain...

Thank you for the reply. As noted in my original post, both computers are running office 2010 v14.0.4760.1000. 32-bit, if that matters. Sample file, original file, results are always the same. When we do it on his machine, it copies & pastes the hidden rows as well as the visible ones. On...

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

ok, I think I have it sorted... I put a line number (26) in front of the first line after Do and then in my error handling I changed "Resume Next" to "Resume 26" and now it seems to be working as I intended.

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

all hail the Ninja. thank you!

sure, see attached.

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

Here you go

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

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

Narayan, Thank you for the response. That works, but it does take quite a while to process on a medium-large range of data like I have. I also realized that for my project I only need to count the unique active customers, not unique active transactions. I think I've sorted out a faster way...

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

Technically it is possible for a 2 digit number to be in there, but it's so rare that I'm not concerned with it. Any value over 8 will stand out very easily to me for other, unrelated reasons. The format does not always follow the style of the example. More examples: {0} {8}{G}{G}{G}...

I'd been working on this for a while, but after another 20 minutes of scouring the interwebs I found a solution. It's not elegant, but it works: using the same example: {3}{G} // {4}{R}{R} add a helper column to pull all the numbers from the cell using this formula...

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

Hui, Thank you for the detailed explanation, but I'm unclear what you meant by "The best way to use time is to use it properly and specify the time as hh:mm:ss". By 'use it properly', you mean only use it on numbers below the integer threshold? In your opinion, is the 'divide by 86400'...

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

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

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)...

Trying the provided formula (with indirect) it locks in row 2 for the formula on every row. I want it to update as it goes down the table (F2:J2 on row 2, F3:J3 on row 3, etc) but the problem was that when I deleted all the rows and pasted in new data it switched from F2:J2 on row 2 to...