Search results

Thanks, I have hit the brick wall now. I was hoping for a non VBA solution. I will keep investigating unless you have any further ideas to solve this. regards GB

Hi Narayan, I appreciate your feedback so far. These formulas are new to me and hard to absorb but I am working through these slowly. The problem with the drop down lists is they won't let me select multiple values as original required. I am heading down the wrong path here or do you have a way...

Hi Narayan, that question/answer came in good time. I will check it out tonight and come back to you. regards GB

Hi Narayan, thanks for tip, I have cleaned up the named ranges, but still have all the issues as described in my first post. Here is my new version. http://dl.dropbox.com/u/60464004/Excel/Dynamic%20Chartv1.xlsx cheers GB

Hi, I need some guidance in best practice to achieve a dynamic scatter chart. I have read many blogs, tried a few things, got confused, now calling for help. I tried using a chart from a pivot table but I want to stay clear from that option as I found it too restrictive in some ways. I am using...

Thank you. regards GB

Hi Narayan, thanks you are always helpful, I will try this out, but do you think this can be achieved using a semi/non volatile formula which is what I am trying to acheive. regards GB

Hi Narayan, yes you are correct, what I mean't was..... all my data is in column A. I want to evaluate if cell A10 is greater than A2:A9 & A11:A19, then moving down to cell A11 (A eleven) I want evaluate if cell A11 is greater than A3:A10 & A12:A20 and so on. Hope this helps. cheers GB

Hi bobhc, it sounds like a simple formatting change is required. Just right click on the cell->format cell->number->custom then choose the h:mm format then OK and your done. regards GB

Hi, I am using the following formula =IF(A10>MAX(A2:A19),A10,"") and copying down 500,000 rows. I would like to know a more efficient way of achieving this result using a non/semi volatile array entered formula. Thanks in advance GB

Thanks again Hui, I had to rebuild my date component back into the h:mm part of the time to get the data to plot correctly, then set the min/max as you suggested. You are always very to respond and I really appreciate it. Thanks Birko

Hi, I'm using version 2010 and creating a chart with my X axis as h:mm and my Y axis as percentage values. The problem is that my x axis data starts at 11:00 and finishes at 02:30 the following day. I am aware that the natural numbers are less (as there is no underlying date component and I...

Thanks Hui, that works a treat. cheers Birko

Hi Hui, thanks for your very quick response although it didn't work for me??? I evaluated the formula and the "Week" component returned a "#VALUE". Any suggestion to rectify? thanks Birko

Hi I am trying to write an index match max formula, to return the maximum "Sales" value where "Week" = 1 and "Day" = Tue. There may be a more efficient formula so I am open to any suggestion. I have attached the simple spreadsheet and all the data has named ranges...

Hi Hui, perfect, thanks so much. regards Birko

Hi Hui, sorry my post did not display as I expected which confused the matter a little. My numbers come like the following in string lengths of either 1,3,4,5,6. See these example numbers directly below, then further down their equivalent time in h:mm. 0 100 1000 10900 235900 which...

Hi, I have imported some data that comes in as a number that I need to convert to h:mm. The data string will be either 1,3,4,5,6 integers long and looks like this...eg Imported data Need to equal this Number h:mm 0 0:00 100 0:01...

Hi xld, thanks, I thought that might be the case. Time for a PC upgrade and/or placing my data in a db. Thanks for your input. cheers GB

Hi, I have a general question regarding performance when opening or saving my workbook as it is very slow. I am using Excel2007, my PC has 2GB ram, workbook file size is 35mb, there are no formulaes, the data is on one worksheet and occupies from A1:DY47486 (which is 129 columns x 47486...

Hi Narayan, a big thank you. I will test your formulaes and see how it goes. regards GB

Hi Narayan & Faseeh, thanks to you both for your helpful feedback, which I have made these improvements. The big question is... how do I get the "Result" to select the correct rows based on my original criteria. Any thoughts would be much appreciated. regards GB

Hi SirJB7, I can understand your sleepiness. Thanks for replying. OK what am I trying to acheive? Every day a Rate is either greater than or less than the previous days rate. The rate will move for example not more than 1.86 in value forwards or backwards each day. Thnk of this movement...

Hi Faseeh, I am not after just the smallest value with a date range. I am after every rate in a date range that stand alone (providing the previous and next record are false. In the case where multiple records in a consecutive block are returned as true then I only want the smallest within that...

Hi Narayan, thanks for your reply. To answer your questions... The MaxRate and Find Rate are always positive values. The FindRate is always <= MaxRate. The only reason I have + & - numbers in the Rate-UserDiff & Rate+UserDiff is to handle the daily fluctuation of when a Rate passes...