Recent content by dronka

Thank you for this offer, Vijay. I'm exploring another avenue with my spreadsheet, so I may not go with this option. If I do, I may take you up on your offer! Thanks. David

These links were super helpful, Narayan. I turned the processing option to manual processing, and that immediately made the workbook easier to work in. I may purchase the FastExcel and see if it can help optimize my workbook. Have you ever used any of their products? David

Vijay - Thanks for replying. Where would this code reside? And what does "Mid Part" refer to? Sorry if these questions are very basic... I'm relatively green when it comes to macros (I can record them and play around with them, but I don't have the bigger picture).

I don't want my users to be able to select multiple items in a pivot table. Does anyone know of a simple way to disable this option in the pivot filter/slicer? Thanks!

Narayan - Thanks for the quick reply! In regards to your first question, is there an easy way for me to find out which operations are recalculating? Good point about the helper column. Just to be sure -- you're suggesting that if there is a formula that uses multiple steps, that I separate...

I'm having some performance issues with a workbook I created. There are some significant data tables (the largest is 38,000 records), and I use a lot of Index functions. I'm having performance problems (the spreadsheet stops to process every few minutes, and it can take up to a minute to...

Thank you, SM.

I have a very large data set (38,000 rows), and I have a lot of columns using lookups from reference tables on other sheets. I'm currently using Index. When I do anything in the workbook, it takes about 5 seconds for it to process. I'm wondering if Vlookup is quicker. Or is there another lookup...

Thank you both for these functions. I've tried Smallman's and it works well. Somendra - It looks like you're using an array formula. My experience with arrays is that they slow things down. What's your experience? And do you think your solution will have higher performance?

I have a very large data set (38,000 rows). I've created a sample spreadsheet (attached) that is much smaller, but that illustrates what I want to do. Table 1 is my data set. Table 2 is a table that contains a list of words that I want to use to search Table 1 with. I'd like a function for the...

Yes, those are good points, SirJB7. Excel didn't make my coffee this morning or pee the dog in single-digit temperature. If only life had macros...

Luke - Your shameless copying was a great success! I made a few tweaks and it works like a charm. Incredible. Is there anything Excel can't do?? Thank you.

I have a product inventory database in Excel. Each item in the inventory has a URL that contains a picture of the product. I'd like to find a way to automatically "grab" the picture and insert it into the spreadsheet so that each product in the inventory contains a picture. Here is an example of...

Thank you for taking the time to do this, Luke! I see that you got rid of the OFFSETS, the nested IF formulas, and the SUMPRODUCT. I'll study your updated formulas to learn how to use them (especially the INDEX). I pulled up my original sample and compared the speed. I'm still getting that...

:)