array range

Hi. I'm trying to build a few tables using named ranges and array formulae but have hit a snag, hoping someone can help. My strategy is to return the row numbers in a data table that match certain conditions and then use these in an INDEX function to return the data. My formula for the row...

I can't figure this out for the life of me. If I was to run For j = 3 to 3 everything runs perfectly. When I run the loop For j = 0 to finalrowcust -1 it adds all kinds of stuff. I've tried to run a For k = 0 to finalrowcust -1 then For j = k to k, but that didn't work. I've also tried...

Hi I am working on a spreadsheet where I want to use built-in MINVERSE() function. However, my array (matrix) size can vary from 2*2 to 50*50. I am going to be using a square matrix; however the size will vary depending on the problem. Is it even possible to use a formula that will 'dynamically'...

Hello, i am currently using HoadleyOptions addin but i am struggling to use on of his formulas in vba, don't know if anyone has experience with this but the setup is as follows; i have 252 daily prices in column A in cell D1 the result of the following formula should be displayed...

I'm getting an object required error and I think it's coming from the for loop. I'm trying to make an array out of the values of the cells in a range and then print them to make sure that I did it correctly. Many thanks for any help. Should be a softy. Sub lookthrough() Dim georange As...