Search results

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

:)

I've uploaded the workbook. The WORKDAY formula is in column Q. I also have a whole load of conditional formatting formulas to get the bars and formatting in the GANTT chart to work. Normally columns M through Q would be hidden, but I made them visible for this sample. The primary function of...

I kind of thought that might be the answer, but I was hoping that some of you Excel Gurus would have a genius way to beat Excel at its own game. Thank you all for posting to this thread!

I have a spreadsheet that uses the WORKDAY formula, referencing a named range HOLIDAYS on a separate sheet. When I added that formula to my spreadsheet suddenly everything slowed down (the formula is in about 20 cells). There is a half-second delay after I do anything in the spreadsheet (which...

I'd like the column width to remain the same (in other words, no double clicking to increase column width). And I agree that wrapping text looks messy (and won't work for my application, which has longer text than is in the sample). See this uploaded file for what I'd like to see happen. I did...

I have a block of cells that each have the same equation in them that inserts into the cell a symbol or text based on a formula. I then conditionally format the block based on the symbol within each cell. The columns are very narrow in the block, and longer text gets truncated by the cell next...

Sajan - Thanks for the array. I will try it out. I have no idea what some of those functions are, but if it works, it works, right??

Luke - What's a UDF code? Would I copy and paste Chip's code into a VBA module and it would then create a new function?

Sajan - It doesn't look like Excel 2007 (which is what I and my colleagues use) has this function. Do you know of a workaround for this?

I think this is exactly what I'm looking for, Sajan! I didn't realize WORKDAY had a .INTL version. A 6-day workweek would be something like Sundays off, and a 7-day workweek would be without any days off (who'd want to do that, eh?!).

I'm using the Workday function in a workplan spreadsheet to calculate the due date of tasks given the start date, the number of days required for the task, and holidays. This assumes a 5-day work week. I'd like to also calculate due dates based on a 6- and 7-day workweek. I found the...