Search results

Thanks Hui cheers..

Hi All, continuing last post i do feel can we run excel 2010 files in 2013 version although i know 2013 have powerful features,can any one explain it. Cheers...

Faseeh,now i get it thanks a lot :)

Hi Faseeh, The formula in your first post works great,thank you so much even it takes a lot of time to calculate but i think its a general issue with all array formulas. Can you please make me understand this part DATEVALUE(1&$C$1:$C$12&$B$1:$B$12))) Thanks again!

Hi Experts, I tried before and got the partial solution of finding the minimum month for a particular project but now i have one more condition where i need to find minimum month out of minimum value year. My first month starts with Oct and ends in Sep Last time i used the array formula(i...

Thanks Roy, I did not got exactly what i wanted but got other nice ideas to implement. Regards,

Hi Guys, Please help me on this. Thanks you!

please someone give your expertise. Thanks,

Hello Experts, I have tried all possible things to put exactly the same text that was given by my client to outlook body in my module using vbline for newline but the text is not coming the way it should appear in outlook email. So,what i have thought now is to copy the text that was given by...

Hi Dhamo, Sorry to bother you,i have rectified it my own now.Just let me know why my 2003 excel is not showing save as PDF format whereas 2010 vs is showing. Regards,

Also,the code sometimes runs very weired,very slow i mean.Any reason? Thanks,

Hi Dhamo, thank you very much for the above code.im using 2003 and 2010 version of excel in my system for the different users.If i save the above code in 2007 xlsb format its working fine but when i do the same for 2010,xlsx format then its saying on the line below that document not...

Hi Experts, I have got a requirement where i have a pivot table with the report filter(vendor name).When i change the filter selection obviously my data changes and i need to convert my result into PDF format which im doing manually using PDF creater in printer option but i want it to be done...

Hi Narayan, i know the above refreshall code to use but the fact is that my raw data is in other file and the name of the file differs each time based on week so i have to manually change the pivot range all the time which i now want to be automated. Looking forward. Thanks,

Hi, Can any one pls help me on the above query? Thanks again,

Hi Experts, Need your help.I have a source data which is a separate xl file and other separate report file which contains all pivots and i do this report weekly.Now what Im doing is that each time im doing the report i have to change the source range for all the pivots separately one by one...

Hello everyone, Apologies for late reply and sorry for my misunderstanding the formula.I tried both the formulas given by Narayan and Koi and both are working as per my need now :).Thanks again for my help.

Hello Koi, Thanks for the reply, for today its okay but how will you find recent date less than today. Regards,

Hi Narayan, No i dont need second instant. Actually i need in range E2 only one result which is 10/1/2012. A2 B2 C2 D2 E2(After applying formula) 10/1/2012 10/1/2012 12/20/2012 9/20/2013 10/1/2012-only one result as per yur comment i need to apply...

Hi Narayan, Thanks for the quick reply but please see the live exampler here i have dates in row2 like this A2 B2 C2 D2 10/1/2012 10/1/2012 12/20/2012 9/20/2013 now i need to know something like this =max(range(a2:d2)<now())i want to get the...

Hi Narayan, the dates will be sorted from left to right in ascending order. Thanks,

Hello Experts, Can any one help me as i have a data arranged something like this where the dates are in horizontal manner in a row like 10/1/2012 10/1/2012 12/20/2012 9/20/2013 and i need to find using excel formula the date just equal to todays or before date using now or today...

Hi Narayan, Sorry to come back again,i implemented the above scrolling word logic and working fine for me but when i upload the file on share point it throws some error for few of my users.Is it because the html tag has to be saved first on the local drive?. Please let me know how one can...

@Narayan, Thank you so much i got it now and its working. You guys are doing great job,keep up :) Regards,

Hi Narayan, Thanks,but i do the same thing i copied the code and pasted in sheet1 and refrenced the internet controls also but do i need to insert any control also in sheet1 to make this work.i cannot understand the code itself how its working.Please help or do you think is there any other way...