Search results

Much appreciated, thank you.

Hi, I have tried various array formulas and keep getting stuck. I would appreciate some help with the following. In cell B2 is where I want to put my answer, by looking in A2 within a string of text that matches something in the range from $D$2:$D$4, then find the corresponding information...

Hi, the following attachment on sheet2, column C is calculating the number of times a number falls within the range in column A & B as referenced from sheet1, Column B. What I want to do is add the following conditions the current formula in sheet2 (highlighted in green)... - If sheet2, A2...

Hi Somendra, thank you for another good solution. Appreciate your help. regards GB

Hi Mike, that is perfect. I appreciate your prompt and helpful reply regards GB

Hi, in my attached workbook I have a some conditional formatting in every second column. The conditional formatting is checking if each cell is a greater value than the one to the right of itself. If TRUE then highlight green. In cell CW2 I want to see if there is a shorter/smarter way of...

Hi Somendra & Prasad, I have just got back to this question of mine and the answer sprang to mind. Here is the non volatile formula that works for me. {=MIN(INDEX(A2:INDEX(B2:B100,MATCH(1,--ISNUMBER(A2:A100),0),,1),,))} Thanks for assistance to help. regards GB

Hi, I have written this formula and want to make it more efficient by replacing the OFFSET with INDEX to make it less volatile. {=MIN(OFFSET(A2,,1,INDEX(MATCH(1,--ISNUMBER(A2:A300),0),)))} What this formula is doing is finding the first cell below A2 to A300 that contains a value then once...

Hi, I have just worked it out. For G3 I would use this formula. =MIN(IF($A$2:$A$72>$F3,IF($A$2:$A$72<$F2,$B$2:$B$72))) with Ctrl Shift Enter. :) GB

Hi Mike, thanks for your attempt but it is not what I am trying to resolve. For example in cell G3 I want to search for all dates between F3:F2 from column A then return the minimum value from column B within this data range. regards GB

Hi, for some reason I can't get this simple MIN IF & MAX IF formula to work. The MIN IF formula I have attempted is to look for all dates in Column A that are between 2 dates then return the min value from column B. I have also done the same for the MAX IF. See attached in cell G3 and H3. Can...

Thanks p45cal, I knew it would be simple (if you know VBA). Appreciate your help. regards GB

Hi, the following code will scale my chart (chart 6) no problem. Now I have two charts on the same worksheet (chart 6 and chart 18) so I want to integrate the commented section of code (the bottom section of code) into one worksheet module. Can you help please? regards GB [Private Sub...

Hi Somendra & p45cal thanks for your help. Yes this will resolve my charting issue. regards GB

Hi, I am having trouble with my chart line scaling correctly. I have 2 variables to control what want to see on my chart... 1. "Start From # Rows Down" - which controls my starting point (ie my row I want to start from) 2. "Data Points" - which controls how many rows of data I want to display...

Hi, just thought I would share another version of my final result which is a variation to Somendra's result. My final formula lives in column E and references the name manager and now ignores the helper columns. Yah. regards GB

Hi Somendra, yes Sheet 3 returns the correct result, thank you. I was only looking at Sheet1. Your initial solution was so complex (to me) and inspired me to vary it to something that I would understand even though it raised other questions in terms of my named formulas not working. Thanks for...

Hi Somendra, if I use your solution (from comment #4) and change the value in cell C7 to 10000, your solution wants to delete both values in C7 & C17. In this case it should retain C17 which would be the minimum. cheers GB

Hi Somendra, I have attached another solution to the problem. In column D (highlighted green) my formula returns the expected results, ie if there are multiple values in column C that exist between the values column B then delete the values that aren't the minimum. The interesting part of this...

Hi Somendra, if I add another value that is less than the others it is asking to delete this value, so there is a bug but I should be able to work it out from here. I will post a reply when I have done it. Don't hold your breath but I should get to it over the weekend. I appreciate your effort...

Hi Somendra, yes you are right, the formula is huge but working as spec'd. Dissecting this and trying to understand it will be a challenge. I see why you want to store part of the formula in the name manager. Great Job. cheers GB

Hi Aman, I am not sure exactly what you want to do but my guess is that this add in (RDBMerge utility) from Ron de Bruin may be what you are looking for. http://www.rondebruin.nl/win/addins/rdbmerge.htm cheers GB

Hi, in the attached spreadsheet I have have array formula that searches for multiple values in column C that exist between 2 values in column B. This part of the formula works fine. The problem I am now trying to solve is ... When my formula finds more than 1 value in column C that exist...

Hi Somendra, thank you, that gives me something to learn from. Appreciate your help. regards GB

Hi, in the attached file I have data in column B and C that I want to evaluate in columns D,E,F,G. I have manually entered four very simple formulas to evaluate the data but it is not a simple copy down to get the results I need, as you will see in the file if you F2 the formulas. I want to...