Search results

Hi Giri, Glad that your problem is solved. Come back whenever needed.. Kaushik

Thanks for such detail explanation Narayan... Mahaveer: I believe, now you are good to go.. Kaushik

I did support the beer industry from the eve of Christmas to the end of New Year and got bankrupt...!! Kaushik

Hi Mahaveer, I don't know but today something is wrong at my end. I am not able to download files. But could you plz have look at the below discussion? It talks about the similar kind of problem and gives the solution as well. http://www.ozgrid.com/forum/showthread.php?t=80024 Kaushik

Hi markjenkins, You may want to read the below discussion: http://chandoo.org/forums/topic/excel-multilanguage-formula-translator-and-function-reference Kaushik

Thank you for your tips bobhc. Actually I assume that OP has month name in the cell instead of complete date. Anyways, how are you? Hope your New Year celebration was awesome. Kaushik

Hi v4wade, I am sorry but I am not able to see any file in the link you have posted; indeed, I am getting error.So I am not able to see any sample data layout your are talking about. But from the explanation of your post I understand that: 1)You want to get the length of the number...

Thank you for your elegant touch Narayan...that is actually very good...I did not think of it... Thank you once again... Regards, Kaushik

Hi mahaveer, The formula that lhkittle posted should be working properly. Can you please upload the two files and let us see if any other issue is there which might be the cause of error. Kaushik

Hi Ramesh, I am sure Hui will reply to you with a more robust solution. But, meanwhile, could you please try the below formula (at B1) for me...

Glad to help you my friend...you have a great day too... Kaushik

Hello Senthil, Your explanation is not very clear to me. You said C3 is the value to be looked up. If that is correct then what C1 is here all about? Can you please post the data layout in a bit proper way (probably by using backtick ( ` ) characters at the bigining and end of your data...

Hi misterphx, Do you think the below link is helpful for you? http://www.tushar-mehta.com/powerpoint/pivottable_in_slideshow/index.htm Kaushik

@Prem... You are correct.. Can you try this? =IF(AND(A1="",A1:A10=""),"Y","N") same with CTRL+SHIFT+ENTER I think Deb's one is more simple, easy to understand and should be working fine. Kaushik

Try this: =IF(A1:A10="","Y","N") enter as an array formula by pressing CTRL+SHIFT+ENTER from your keyboard. Note: Formula will return "Y"if all the cells in the range are blank, if any one of the cellls conatain a data it will return "N" So in case of my above data example, this formula...

Hi vijaynpd, First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here. As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site...

Hi Prem, Suppose your data ranges from A1 to A10 as follows(A2,A6,A8 are blank cells): A B C D F T M At B1 write the below formula: =IF(A1="","y","n") press enter and drag it down. Hopoe this helps. Kaushik

Yes you are correct Raja...My apologies!! But you can overcome this challenge by writing the below two lines of code. Double click on Thisworkbook (under project explorar) and write this code: Private Sub Workbook_Open() Application.DisplayFormulaBar = False End Sub Private Sub...

Hi Gumbles, Another workaround for this would be to create a named range and pass the same in the COUNTA function: Say your data is from A1 to A10. Press CTRL+F3 from keyboard to bring "name manager dialogue box",Click on "New", in the name box give any name of your choice (Say "MyRange"...

Hello Pavi, Can you plz answer my below questions? 1)For salesmen, what is the performance parameter(col heading) and what is the target? 2) For customer, which Cols should I consider for performance and budget? Kaushik

Hello Raja, What about doing the following: 1)Uncheck the formula bar (Excel office button>excel option>advanced>scroll down a bit and uncheck "show formula bar"). Hence user will not be able see the formula in the formula bar 2)Protect the sheet (F2 will not work to show the...

Hi T100, Another good place to learn VBA is this forum itself. I would like to advise you the following: 1)Visit the forum everyday (if possible) 2)Analyze the solution given by other members on many VBA topics (you can search the topics by google custom search), understand them and try...

Hello ianb, As Narayan rightfully said that speedy share does not require any account to be created, just try to download the file once you are at home. I am sure you will be able to download the file. In case you still can not download the file even from your home network, let me know your...

You are welcome Raja.. Kaushik

Glad that your problem is solved. Kaushik