Search results

I wanted to start my reply with this piece of "code" the most important in this thread up to now (in my humble opinion). Not directly relative with this forum subject but more of a stance in life i could not let it pass by . Seems i have give enough elsewhere to get now ,here ,from Vletm (and...

Hi again and sorry for my late response. Obviously vletm , your excel has been grown to do more than expected (even a newbie like me can see it). Once more much obliged ! Allow me though some questions which i do not understand. 1. What tricky effects could be? Can you give an example? Since...

Vletm i am grateful for your time and your code. What i wrote above please not be taken as a critic (i do not have the knowledge to do this anyway). I am terribly sorry if it was taken likewise. I was just trying to understand the different versions of the suggestions. Nevertheless vletm's...

First of all thank you all for your answers. It is more than obvious that there is much Excel knowledge power gathered in chandoo forum. Judging from the results of the excel's you submitted, they all seem to do the job well ,with 2 of them failing to identify 1 product and 1 Excel (Bosco-yip)...

Hi all, This is not a simple question and is definitely high above my limited knowledge of excel so i need your help if you may ... I have an excel (attached) with 4 columns. Column A has product names and Column B has their prices. Column C has other product names and Column D has their...

I see. So it is only a matter of syntax to direct the formula to look at the other excel. Thank you very much for your answer SirJB7. Regards.

Hi all, is it possible to compare columns of similar type e.g. products from different excels using the Index and Match functions or they have to be in the same excel? Example: I have 2 excels. Each excel has 1 column with product names. Do i have to merge them in order to use Index and Match...

Hi again and sorry for the late response. Thank you all for your answers. It seems the problem was that i had decimal points "," as SirJB7 said and by changing that the Text to columns works ok. Before i change the decimal point symbol the "lens" which narayak suggested worked also. One more...

I atach a screenshot with my regional settings ,i do not know if this is enough.If not tell me what else is needed . Regards.

Thank you very much for your replies. I tried these yet the cells are not converting. It is very weird that excel cannot do a so simple task so must be me doing something not right. I attach a sample of the file so you can see on your own if you wish. Regards.

Hi all , i have an excel where one column is like this: EUR 203.86 EUR 211.21 EUR 214.55 EUR 214.55 I would like to turn this column to numbers. Since i am newbie in excel (but not lazy) i searched in google and tried various stuff that is suggested but nothing seems to work. This is very...

Knowledge is power . Narayank powerful ! Thank you , Regards, the_observer.

Thank you much Narayank. The second way works like a charm. Thank you mate. The first way though returns a #NAME? in the cell. I will continue with the 2nd way i guess. Thank you again. Regards, the_observer.

Hi all, i am trying to highlight high and low values in a chart as the title says. I do not know excel but by searching around i found two ways to accomplish this but i have not managed one of them to work. Both ways suggest to create two more columns (one for min and one for max values) and...

Hi again. It seems that rng.Clear although it does what i asked for, it is not good for my specific excel because it completely delete the formatting and data. So i decided to replace it with rng.ClearContents so it deletes only the data as Narayak suggested in previous post. Now what remains...

Well .... yes. Thank you very much bobhc. Regards, the_observer.

Sorry i was not clear. I mean ,when i create a new workbook not one already existing like yours smallman. Of course smallman,i could use your document every time i want to create a new excel. Or i could insert the conditional formatting rules every time i create a new document. I am just...

Hi all. After the successful resolve of the colored rows question in the above posts :) i would like to ask if it is possible somehow that i can have the conditional formatting rule talked above set by default when i open a new workbook or sheet. Thank you for your time reading this...

Thank you all for your answers. Smallman's post did the job :) Regards, the_observer.

Thank you for your answers. They give me much wisdom. In aurelie's answer , what should i put/ how should i syntax the Selection tobe e.g. specific cells of 2 rows? E.g. lets say i would like to clear only cells of column B and D . For B lets say 3 to 7 and for D lets say 12 to 20. I don't...

Hi all. My question this time ,regards to the creation of a button. What i would like to do is to have a button somewhere in excel sheet which when i press it, it will clear specific cells from content and from color. Can this be accomplished in Excel 2003? Up to now i have found this post ...

Yes it works great. Thank you very much for your answer. Regards, the_observer.

Hi all. I would like to ask if there is a way that when i click a cell the row and column of the cell to become automatically highlighted in Excell 2003 and 2007. Thank you for your time reading this. Regards, the_observer.

Yes , that is exactly what i need. Thank you much Narayank. Now ,your other comment about : Just as an aside , if the first CF formula ( the one on top ) is : =MOD(ROW(),2)=0 the one below can be : =1 what is it? Is it something i should know or ignore it? Thank you for your time...

I really have no idea what this is for. Be patient with me i am so newbie :( I also have another question. Is it possible that i see grid lines? I ticked the option in the View->Gridlines but still does not show them around the area where i apply the Conditional formatting you suggest. Thank...