alternatives

Hi all, I'm trying to replace a named range in my SUMPRODUCT calculation, in order to speed up my sheet. I'm thinking it's some sort of combination of INDEX, MATCH and COUNTIF, but can't crack the code If the below range is located in A1:B7, and I'm trying to return the in range in column A...

Hi all, If I wanted to create a name ranged of the cells in column A, starting when column B says "Equity", and ending when the work "Fixed Income" starts, how would I go about it? (i.e named range should = A5:A15) I've tried something like this but no bueno...

Hi All, I hope I am posting this in the right place... My company makes complex medical devices, and for which I developed an Excel based service reporting tool. The service report does a couple of things: it guides the service engineer through exactly has to be done based on the service they...

the disadvantage of sumif is that if we use a different source file, then when we close the current file, the results of our formula will change to #value . Do you know what the other alternatives besides sumif

Hello Everyone, I'm having a problem relating to resetting last row/column in Excel. I've faced this problems many times and haven't found a proper solution yet. I've used the Ctrl+End and deleting rows/columns, clearing all formats, and even used Excels built-in add-in (Inquire-Clean Excess...

Excel 2013/2016 <colgroup><col style="width...

Hi All, I originally posted a question here about Syllogisms (If A = B and B = C then A = C). Here is the Spreadsheet I need help with. !Please note that to reduce calculation time, I’ve removed all but a text version of most of the formulas, which can be found at the top of their respective...

Hi This is my first post, so I'm not sure how to upload an image of my example table, apologies if it makes no sense. I've been unable to find an answer to this (mainly because I'm not sure if I'm searching on the right term) I have a list of 20,000 products, some of which can be used as...