Search results

hi, Thanks for your reply So, what you say, is use any excel of 32 version and the macro will work. Will try. But please say, why the dll file has to be installed in system folder. I have worked with macro files which would prompt , enable macros if you trust the source warning and enabling...

Hi, I do not know macros. There was a excel macro sheet sent for my use. On opening it, I receive compile error. On clicking ok, button, on opening the excel sheet, there are value, name NA errors all thro the workbook. It was a workbook with macros version 97-2003. Elsewhere in the discussion...

Hi, chihiro thanks for the answer. i downloaded the template from this link. The above link gives the idea , but i could not find the same. But i found it here https://templates.office.com/en-us/Family-tree-chart-TM01021967 thanks

Would you elaborate, i do not want any online tool. i want excel

Hi, If it all what you cannot change is the parents and relatives and their relations in this world. I really lack the details on the heriditary details of a family member and his sons daughters , son in law and daughter in law. As we pass on and grow old, we could not remember the heriditary...

Hi, Bruce, The link you mentioned is the exact link i tried with my positions but solution greyed. May be the site wants some perks to solve your problem

Hi, I am glad that some kind of thought on this emerges. Taking that white as top and giving nos 1 to 9, and by giving the numbers up to 54 for each side, could there by some visible solution to try a kind of permutation and combination analysis to do ...

Hi, Is there a simple way to solve the Rubic cube. I know it has edge pieces, and centre pieces and 3 rows and their move are restricted to spin and rotate. Is there a way, excel way, to how to solve the scrambled cube...

Hi, I have informed that the solution given by you has worked. I want to know a little more about the custom formatting of [>1000]mm/dd/yyyy;h:mm AM/PM does. I want to know what this denotes . [>1000]. If person like you say something more about what this means, the users of forum would...

Hi, Luke M, When i tried with separate date and time in A2 it has worked wonderfully. Thank you. Could i expect a reply on what the format you have given is doing.

Since the custom format includes time format, i tried that. When you could format the cells with date and time with excel, i had the doubt, whether excel has some inbuilt function to this one. I found in one of the programs, that it has //separators, and you need to give only the 8 digits, it...

Hi,Luke thank you for informing no function When i enter the formula after i input dates and time , i get num error. What should i input if i have to get the input 12/20/2014 05:35 pm in A2 to get in some other cell? what should i type in a2 to get the date only in...

No, i want to enter the date and excel auto separate the entries to the chosen format in the same cell. Is there any tip or function

Hi, When i format a cell with time or date, i have to format the cell and also has to type manually the / / or -- format for date or : for time. Is there any tip, or function in excel where in it is possible to auto separate the entries according to chosen format. For eg. when i...

No. it is working perfectly. What is the problem i am facing is if you copy the formula and paste it somewhere, it gets the value and not time, so the problem. Now it is sorted out. You have to first select the entire column with custom format time in dd/mm/yyyy h:mm:ss and then enter the...

I have seen that. But it is a macro. I tried this tutorial by the author http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/ But when i apply that it gets the time stamp in b column after applying iterations as suggested. But , the time stamp changes to real time when another cell...

Hi Narayan Thanks for the reply, Would you say little more about accepting a timestamp entered in a helper column. Please explain this. Where and how to enter timestamp, and how to view the latest updated. is that also require vb or just window menus. Please

Hi, i am having a excel sheet in which i and my staff will be updating. This is a regular worksheet, having names and some data. I will be updating the data to selected rows,this week, some other rows in next week and so on. It gets updated...

I solved the problem myself. You have to select the cells that has borders and then right click, format cells, then border tab. there you have to select the line style you want and then change the colour and in the centre border preview box, apply for all outer borders with required colour and...

When a question is solved, if it is marked as solved then any search engine user, if searching may find it very useful as SOLVED one. Normally user search for excel and other questions, by including solved as a starting string in the question. for eg Solved How to change the...

Thank you so much sm, The error i would definitely correct in my future work. Some formula do work if the condition match, and some if it does not. Thank for putting me on the right path. How to close this thread as solved and i do not find any kudos or similar button to...

This worked perfectly well. Pl point the error i have done and also, the inclusion of two ifs, and also, 1,0, so that i could further improve upon. Thannks

The question is about bordering in excel. I could change the font colour , but could not change a colour line of the border in excel 2007. How to do that . I am having excel ribbon

Thank you so much for the explanation. i tried the formula with but resulted in error. =if(and(a1:a6=200,150,"")) but got the error answer. so, i asked the question.I even tried by cont.shit,enter, but the result is wrong. Now, if count formula gets me the correct answer.

Thank you so much for the clarification. Would you throw some light on what an {} formula. How it is different from the one you give me as solution. Thank you sir,