Search results

Hi Asheesh, thank you, works fine. regards GB

See attached of an example file.

Hi, I want to use an INDEX formula (non volatile) instead of an OFFSET formula as their are thousands of OFFSET functions within my spreadsheet. This formula is wrapped inside other calculations so I only need help with an alternative to this. My current OFFSET formula looks like this...

Hi Narayan, the performance issue has been resolved thanks to your suggestion in placing the MATCH($A1,qDateDFC,0) formula in its own helper column. Much appreciated. GB

Hi Luke, yes, the single cell named ranges are volatile. regards GB

Hi, I am using the following formula (in Excel 2010) to test if a condition is TRUE or FALSE then summing the result from the previous cell above as I copy down each row (210,000 rows x 12 columns). All named ranges are single cell references except qRange, qDateDFC which 6000 rows x 1 column...

Thanks Luke, I thought that may be the case, but you never know as there are usually so many ways to solve a problem. regards GB

Hi, I am trying to chart the following data (without using a pivot chart, although I am showing a pivot chart below for demonstration) and I am having problems because of the "rsSeries" column. I want the X axis to be rsDate, rsAmount to be plotted by rsSeries and rsDate. Is this possible...

Hi Somendra, that is very helpful, thank you. regards GB

Hi, Somendra, thanks for your reply but I want to write a formula rather than used the Advanced Filter as my search values will change a lot. No doubt it could be complicated (for me anyway) so any help would be great. regards GB

Hi, I need some assistance with creating a formula to filter a list. In the attached workbook I have unfiltered data in columns A:F in columns I:K is my search criteria in columns N:S are the results of the search The search criteria requires matching the "Series" from column I & "Level" from...

Hi, I have a problem which I can't solve efficiently (but I can solve in some clunky steps). I am asking for your help. The file attached contains all the data and also a copy of the instructions of what I am trying to achieve. Below is a copy of what I am trying to resolve but it won't make too...

Hi Hui, what you have provided is very helpful. That little bit of guidance helps. I notice you are driving the visible charts days by the look back period, which I will try and tweak so that visualization comes from a separate cell value. BTW my top set data wasn't meant to change but that's...

Hi, attached with this post is the daily trading ranges for the DAX Cash Index that contains 2 worksheets (Dashboard & DAX). I have built a scrolling chart (on the Dashboard worksheet) that displays one year at a time then scroll through the data. It’s done in a 2 step process. You will see the...

Hi Smallman, it works perfectly. Appreciate your help. Thanks GB

Hi, I have a large data set in one worksheet (Sheet1) of my workbook. I want to find all cells that begin with, end with, cells with exact match, or contain, then delete these from the worksheet. See example... abc* *now dog mat *ouch* Does anyone have some vba code I can reuse to make this...

Thanks Smallman, I have tweaked your code to suit. Its works perfectly. Thanks so much. GB

Hi, I am trying to merge multiple workbooks in one workbook on one worksheet using some vba. All workbooks that I want to merge together are in the same file directory. All workbooks have multiple worksheets, but I am only interested in merging the worksheets named "abc". I want the data from...

Hi Vijay, thanks but I was aware of this step per my original post. I have just found a way to do this. Go to File->Options->Advanced then scroll down until you find the "General" section then uncheck "Ask to update automatic links". thanks GB

Hi, I have multiple workbooks, that when opened each workbook tries to link to an external source for updating. What I am trying to do is to join these workbooks into one workbook, but before I do that I want to remove the link from each workbook. I know how to do this individually but not...

Thanks very much, that works perfectly. regards

Hi, can you help with me solve the following problem please? In column A (range A4:A100)each cell contains either a "Y" or "N". In column B (range B4:B100) each cell contains either the number 1 or " ". When I use the autofilter on column B and select all cells containing 1, I want to count the...

Hi Narayan, thanks that solves a mystery. It was puzzling me for a while. cheers GB

Hi Hui, thanks you are right it does fix it and I can work with that solution, but I checked for rounding by writing a formula and found no differences? Anyway its OK and appreciate your help. regards GB

Hi, here is an interesting problem... when referencing a date/time calculation and performing a vlookup to another table in some cases the item returned is correct and in other situations it is #N/A. When comparing the cell value in cell B5 and the values in the lookup table they match exactly...