Recent content by RedBean

Thanks a lot for the help! It worked great. I know that my request seemed a bit strange, but the data I am working with is incomplete and this was the only way I knew that would get me the results I needed. Thanks again.

I have orders that contain varying number of items. The majority of the items will have the same quantity, that is the number I am interested in for each order. So I group by order and do a running total with Nth most frequent with N = 1. Now there are various types of orders and I need a sum...

Thank you very much, nsukari. Your solution worked great!

I have a table in the following format: REGION REP# NAME STATE SALES A 0031 Joe MA $10,000 A 0302 Mary CA $15,000 A 0063 Mike TX $15,000 B 0004 Bob NY $7,000 ... What I want to do is return for every region the person with the highest Sales...

Thanks for the replies, guys. I am going to use arb4's solution since it runs much faster. I am so glad I stumbled upon this forum, you guys are the greatest.

Hi, I have two tables the first one contains the history of book sales and looks something like this: CUST# BOOK# QTY 12345 A9999 1 12345 B0001 2 98765 A9999 5 99999 C0009 2 ... The second table just contains a subset of books that I am interested in, like: BOOK#...

Is there a way to reference both another cell's value and formatting? I have 2 sheets, one with book numbers and their current status and the other with orders. I have the orders sheet perform a vlookup on the book number on the book number page. While this gives me the current status of the...

Thanks, dgillz you really are the greatest. :) That was simple enough. I could have sworn I already tried that, but I guess not. Thanks again to everyone on this board, most helpful place I have ever been to.

Let me see if I can explain this a bit better. Right now I have a report which has a one-to-many link, so pretty much several records would have all the same information except for the Credits field. (I just realized the example in my first post was not correct, this one is more of what it...

I tried to do that, but it would sum up the duplicates that show up. I just want to sum up the amount once for those invoices that are duplicated because of the one to many relationship. Doing it the way dgillz suggested seemed to have resolved the duplicate problem. Is there a way to use a...

Well, I am looking to have a breakdown on the amount for H status items and those that are anything but H. If I understood what you suggested that would give me a total amount for all regardless of status. If I misunderstood your post, can you please rephase it in a different way? Thanks for...

Hi, I have two tables linked in a one-to-many fashion. One contains the Order#, Amount, and Status and the other contains Credits among other things. It looks something like this: Order# Invoice Amount Status Credits 1 A $10 H $1 1...

dgillz: I followed what you said in the other message and it worked perfectly. I entered the formula into the group selection window. The thing was even after doing that, the grand total at the end was the same as before the selection. So I tried to choose records meeting a different criteria...

Hi, I used dgillz solution to my previous problem (thread767-319175 and that worked great. The problem now is that my grand total at the end of the report includes all the groups, even the ones that were filtered out with the group selection formula. I just want to sum up a total for the...

thanks for the help, dgillz