Search results

Thank you all. Anyways, If one has to learn something, especially a technical thing like VBA, he has to buy a hard copy rather than depending upon a downloaded soft copy. Regards Carlos

Hui, Good morning, I need your advice on good books on Excel 2007/2010 and VBA. I am an advanced user of Excel for the last 10+ years. I explored a lot in excel, but I am frightened to touch VBA seeing the code and all. I have a flair for VBA and I tried hard to love VBA but somehow I...

SirJB7, This is working fine. Thanks for your effort. Hui, What you can see there is the processed data before my enlightenment, worked with each cell separately. What I am trying to do there is " trying to write a formula that contains some variables with relative ref and some with...

SirJB7, This is working fine. Thanks for your effort. Hui, What you can see there is the processed data before my enlightenment, worked with each cell separately. What I am trying to do there is " trying to write a formula that contains some variables with relative ref and some with...

Hi All, Anyways this is the replica of the problematic thing. https://hotfile.com/dl/165055522/b91f674/State_Rainfall.xlsx.html My problem starts at the "look-up_array" variable in the index function. It behaves in a different way with others. See the other relative references. I want to...

Hi Hui, Good evening, I need to use a combination of index/match function in a cell and that should be copied 7500 rows downwards and 356 columns across with only some cells carrying relative reference. Which is the best choice of action in that kind of scenario. For eg: If I use this...

Thank you, Hui.

I am working on a presentation. I need my cell borders to look like the torn edged paper styled/ rough edged for one of the header cell where I can fill the contents in it. Is it possible in Excel 2007 or 2010? Thank you all.

Thanks for your suggestion. I am trying to do what you have suggested me suitably.

Hui, This is fine. But how should I plan for the coming years. 1) I will add a sheet every month, 2) I keep on adding new Customers. These two are inevitable. And at any time, I should know the sales figures with out any error and time wasting. How can I capture everything in the summary sheet...

Thank you for the promptness, I will test it on my end for my suitability because Customer base keeps growing up every month and we need some dynamism in the file. I will let you know, if I come across a glitch. Thank you, Hui.

Hello Anybody, I am here again with another headache. I came up with a problem in preparing the summary of a particular product(10 types of items) for all the 12 months for a particular Customer(no of customers 450+). Because the no of rows in a month is different from each other. That is one...

Hi Srijith ! Welcome to Chandoo.Org, What are those figures with %s? Any relation to this data and let me know what exactly you want to achieve. Otherwise post your spreadsheet for details and give me some background of this task. Carlos.

Hui, Hay una gran cosa mañana. Estar listo. Gracias. Adiós.... Carlos

Hi Narayank991, Thank you for your suggestion. It's done. It's working fine. Thank you.

Hui, That's a wonderful solution. You saved my life. I fed the same formula to the remaining cells as well. It's working fine. I will make it as a template and preserve it for future. Now whole work is a click away. Thank you so much... Regards Carlos Ramirez

Hui, I appreciate your effort. Seemingly,I might not have asked for the right solution. But somehow it is not working the way I think. Anyways, This is the requirement: I want to post the marks for each subject , both for internal marks and external marks Roll no wise. How can I drag all these...

Hello SirJB7, First, thanks a lott for the quick answer for my query. I could not implement that formula in my worksheet. Probably it is because of the incorrect placement of the "1s" in the formula. I could not judge correctly where to place the "1s". Anyways, I am going to give the actual...

Chandoo, I have a 70,000 row deep exam results worksheet(Excel 2007). I want to copy every 9th row from this sheet to a difference sheet. Is there any formula to work this out. I can send the workbook if somebody is ready to solve. It's fairly easy with excel seemingly but I have no flashes.