Search results

I figured out a way to avoid the problem. Instead of deleting all the data in the table before pasting in new, I leave the top couple rows. That way it doesn't change the reference from F2:J2 to F2:J20000. Thank you for the suggestion of indirect, Debraj. That's one function I haven't sat...

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

Kris, That worked brilliantly. Thank you!

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

I think I'm trying to accomplish the same thing. I've got a list comprised of account number, total $ of invoices, ADP (average days to pay), sales region, and salesperson. Since the ADP is already an average, if I use "average of" in the pivot table it will return a flat average of the...

Excellent, thank you very much. I was trying ROW() or ROW(1), not thinking it must be a cell reference. I appreciate the explanation. idk

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