Search results

Hi all, I was wondering is there any way to decrease the size of the spreadsheet with 300,000 rows of data and increase calculating speed ? I've used very simple formulae to ensure the increased performance but its ever growing data is causing big problem. Also what if I reach the maximum...

Hi Faseeh, Thanks for the reply. There are few questions though. I tried breaking down the formula apart to see different results on how they work. I am little confuse why ROW(D11)-1. For example in your previous spreadsheet cell "J13" contains the formuale mapping to ROW(11)-1. Shouldn't it...

I believe that is because of the array formula. To fix that please enter "ctrl+shift+enter" combination in cell, whenever you try to change formula. Cheers.

Hi Faseeh, I had a look at your spreadsheet and your formulae is awesome. Will it be possible for you to break down the formula ? Thanks for your time. Z.

Ah let me try this link provided by: NARAYANK991 http://www.get-digital-help.com/2009/10/25/how-to-return-multiple-values-using-vlookup-in-excel/ This might be what I need to look for. Thanks, Z.

Hi All, Hope you all doing great. I've got a question which has been bothering me for days now. This can be done using either pivot table or VBA but what I want to find out is how to drive the same results using formulae. Assume that we have value as below in Sheet1: Name Cost Code...

Hi Trickyd, Will it be possible for you to provide few example data set and the results you want it ? Cheers, Rahul

hi, have you tried formatting cells as number with 2 decimal ? Cheers,

Hi DonMinter, This formula is great and works perfectly but now I am in a situation where I need to look at codes (text strings) and I can't make it to work. I tried Vlookup & Index matching, they both works fine only for one condition. Can you guide me which formula to look at for these type...

Try this please =IF(ISNA(INDEX(A1:A50000,MATCH(C1,B1:B50000,0))),"Does not exist",INDEX(A1:A50000,MATCH(C1,B1:B50000,0))) Cheers, Z.

Hi Dan, Can you tell me what exactly your output suppose to look like ? Thanks, Z.

Hey DonMinter, You are star !! I have found what the issue. I thought my spreadsheet might have been acting weird as you've mentioned about some formatting issue. I started a fresh spreadsheet and Voila !! Thanks again for your awesome input onto this and I will update you once again in the...

Hi Don, Thanks for following up with me on this. Your formula is absolutely perfect. How I actually want the formula to work is: For example I have a date range of: 01/01/2012 - 31/01/2012 User is A & £ 10 cost We can interpret this as User A have cost of £ 10 From 01-31 Jan 2012. That...

Hello Vargeesh, glad it works for you. Thanks for the typo correction and explanation @DonMinter. Cheers !

Try using this ? Paste this in column D and if you input any code in Col C the name should appear. =INDEX(A1:A50000,MATCH(C1,B1:B5000,0)) HTH Regards.

Have you tried using VLOOKUP() formula, that might help ?

Hi DonMinter, Thanks for helping me with this, though the formula you've provided is awesome this doesn't help my case. Is it possible to modify the following formula =INDEX(F2:F8,MATCH(J9&K9&I11,C2:C8&D2:D8&E2:E8,0)) to something like...

Hi Guys, I have been playing with quite alot of formulae since the last chat but still haven't got quite what I really want. I really need to solve this thing asap. Please can i have some idea on this ? :) Cheers !

Yep, doesn't matter which page I open with the excel browser, shall I put. It shows script error :( Thanks Luke M & NARAYANK991 for your awesome help !

Hi NARAYANK991, Thanks for helping me on this. I am going to do few research on the link you've provided. Currently I am having a little bit of problem with the excel data query browser. It is giving me script error everytime i open a link with an option to stop script (yes, no). Any idea...

Thanks Luke M. I totally agree with you, it is very hard to just "pick up" :))

I am trying to get the table from a web page direclty. This is first time I am learnin/using this function and haven't quite got a grip on it. The problem is that there are some occasions that it won't let me select data. Also I can't even select what data I want. It let me select the whole...

I am in the same situation here Hunnycool. I believe if we know how to use access that would be awesome because after row 65536 excel becomes very difficult to process !! Here is what I am currently looking into : http://www.functionx.com/access/ Cheers !

Hi Hui, Thanks for the reply. Unfortunately this formula is still not giving me the answer I want. So for example if I use the sumproduct/sumifs formula and change the date range it will give us zero. Literally I will have to add 30 lines for each month just to show the data for all the...

Hi All, I am having some serious problem with multiple criteria matching. What I want to do is to match three criteria (Start Dates (A1),End Dates (B1) & User names (C1)). The results is in (D1) and each row is unique. The current formula which I am using to multiple match is as below...