Search results

Thanks Narayan, I can learn a lot from what you have shown me. This works fine. regards GB

Hi Narayan, thanks your formula for step 2 is perfect. Is there a way to take the results of Step 2 and show in the ordered fashion as per step 3? regards GB

Hi, can someone please assist with returning values from a range of data. The problem & requirements are clearly documented in the following attachment. https://dl.dropbox.com/u/60464004/Find%26Show.xlsx Thanks in advance. regards GB

Thanks Narayan, that really helps. cheers GB

Hi Narayan, sorry I didn't order as suggested. I re sorted the file and the formula works, thanks. If I left it in its current sort I assume a different approach would be required. Can you suggest something? cheers GB

Hi Narayan, your formula doesn't work. I have attached the spreadsheet so you can see. I would appreciate it if you can have a look. https://dl.dropbox.com/u/60464004/Excel/MultipleLookup.xlsx regards GB

Hi, I was reading the post on "multi condition lookup" but I could not manipulate to do the following... I am working with a time conversion and I have three columns of data (Place, Date, VarGMT). An example of the data is... Place Date VarGMT LAX, 14Mar2010, -7 LAX, 07Nov2010, -8...

Thanks Chandoo, you are a gentleman. Thanks for taking the time to answer. Elegant solution. cheers GB

Hi, I have my bank records downloaded to excel and I want to remove some of the noise from my "transaction description" column and place this noise into a separate column, so I can sort and categorise my records in a good way. For example many records start with "ATM#245367-" or "ATM#854910-"...

Thanks Narayan, that works perfectly. cheers GB

Hi, I have in column A a series of dates (ascending). In Column B I have values. eg Date Value 01Mar12 6.75 07Mar12 7.00 14Mar12 9.34 I want to do a lookup on a date to find its corresponding value, eg what is the value for date 10Mar12? If this date doesn't exist in the table...

Thanks Mercatog and the rest of you for contributing to the answer. It was so simple, I feel dumb for asking now. That's was happens when you come back from a long holiday, you brain goes numb. cheers GB

Hi, I have been given a spreadsheet that contains a formula like so... Cell B1 contains =A1*3.89 Cell B2 contains =A2*10.67 etc What I want to do is extract each constant value in column B from each formula and place it in column C. How can this be achieved? Thanks in advance GB

Hi Chandoo, very impressive, thanks for the explanation. I'm sure I will learn a lot from this. regards GB

Hi Ninja's you guys are so helpful. The time it takes for one of you to respond is always amazing. I wish I could contribute more, but you are all much smarter then me. cheers GB

Hi, I am trying to solve a problem where I have a series of circles with numbers in them. Each circle, as it expands has 8 more numbers than the previous circle. What am I trying solve? Lets say I select number eg 23 and I draw a line out from zero (the centre) through 23 and beyond. What I...

Hi SirJB7 & Narayan, here's what I came up with that works for me. =IF(LOOKUP(N2,INDEX(A8:P34,L1,0))>L2,LOOKUP(N2,INDEX(A8:P34,L1,0)),"") Thanks again, you both got me thinking. regards GB

Hi Narayan, to answer your questions... - blank - won't be possible to have multiple results in my case, but a good question. Hi SirJB7, I will try your formula (I am sure it works), then spend some time trying to work it out. Thanks to you both for quick response. I really appreciate...

Hi Narayan, thanks but it doesn't work correctly as your formula ignores the lower limit (cell L2). Any other suggestions? regards GB

Hi, I know this should be simple but for some reason it is not. I have a range of data. In column A I have numbers. To the right of each number in column A I have a range of numbers that are progressively bigger than each number in column A. I want to find a number in column A then in that row...

Hi DC, check this link. It may what you need. http://www.contextures.com/xlautofilter03.html regards GB

Hi Luke, thanks for responding. In the example I provided you are correct (there are three numbers that are between 2000 & 3000) for my example provided. In reality the value in A1 & B1 will change, therefore the copy down of the formula will need to expand or shrink to find the answers. I...

Hi Smarter Ones than me, I am trying to solve the following problem in a clever way, can you help? I have a number in cell A1 (eg 250) and another in cell B1 (eg 3. Note B1 never changes value). I want to find the square root of A1 then add B1 to this number then re square this value to a...

Hi Narayan, can you provide an example so I can build on what you show me as I haven't used these before. cheers GB

Hi Narayan, typically 6 on the primary and 6 on the secondary is what I want to see, but no limited to these values. My max will be 8 and min will be 4. I was hoping my 1st post was clear enough on what I was trying to achieve. Which part do you need further information on? regards GB