Search results

Hi, Can you please check the below file. https://www.dropbox.com/s/sxlg4rhr9l0go5y/Login%20Dump%281%29.xlsx Thanks, Suresh Kumar S

Hi Indian, Can you please share the concepts with us. Thanks, Suresh Kumar S

Hi, My suggestion is rather than having two concepts in one shape you can have the macro code for hyperlink also. Thanks, Suresh Kumar S

Hi, Can you please try the below formula. =IFERROR(RANK(B2,$B$2:$B$13,0),"") Thanks, Suresh Kumar S

Hi Ranjan, Can you please try the below link. http://www.excelbanter.com/showthread.php?t=241282 Thanks, Suresh Kumar S

Hi SP, I am working on the file this weekend i will upload. Thanks, Suresh Kumar S

Hi Rana, Can you please overwrite the below code. (under userform - select userform and press F7 and delete the old code and paste the below code it will work) Private Sub MonthView1_DateClick(ByVal DateClicked As Date) ThisWorkbook.ActiveSheet.Range("H7").Value = DateClicked Unload Me...

Hi Pavi, Can you please upload the workbook. Thanks, Suresh Kumar S

Hi, Try to create the chart inside the powerpoint. http://office.microsoft.com/en-gb/powerpoint-help/use-charts-and-graphs-in-your-presentation-HA010108502.aspx Thanks, Suresh Kumar S

Hi Jai, Can you please try the below formula in "F2" and check whether you are looking for this. =IF(COUNTA(B2,C2,D2)=3,IF(B2<>C2,IF(C2<>D2,IF(D2<>B2,"Y","N"),""),""),"") Thanks, Suresh Kumar S

Thanks Hui & Oldchippy

Thanks buddy

Hi Shri, For 1.208 & 1.098 it will work but for 1.100 it shows "1.1 done" but i want "1.100 done" and it will work if we change the format to text for 1.100 cell. Thanks, Suresh Kumar S

Hi, Suppose i have a set of number 1.100 1.208 1.098 and i want to add text " done" to the list with extact value like 1.100 done 1.208 done 1.098 done How it can be combined using formula. Thanks, Suresh Kumar S

Sorry about that, https://www.dropbox.com/s/ptgu5in1qxo4fam/2.xlsm Try this.

Hi, I have created a dummy workbook as per your request if you are fine with this please modify the code for your workbook otherwise igonre any one of our excel hero will help you. http://www.2shared.com/file/-bGZ5j0D/2_online.html Thanks, Suresh Kumar S

Hi, VBA code password is required to view or modify the code or remove the password and upoload. Thanks, Suresh Kumar S

Hi, Can you please upload the sample file. Thanks, Suresh Kumar S

Hi, Can you please download the below file and check whether you looking for this kind of report. http://www.2shared.com/file/eLLKlDqs/5_online.html Thanks, Suresh Kumar s

Hi Kdibai, Please insert a module and paste the below code. (This is fixed code as per my knowledge) Sub findreplace() If Range("a1").Value = "APPLE" Then Range("c1").Value = "ARGENTINA" If Range("a2").Value = "LEMON" Then Range("c2").Value = "SPAIN" End If End If End Sub Thanks...

Hi, Can you paste the below formula ("B28") and check. =INDEX($B$15:$G$25,MATCH($A28,$A$15:$A$25,0),MATCH(B$27,$B$14:$G$14,0),MATCH($A$27,$A$14,0)) Thanks, Suresh Kumar S

Thanks sgmpatnaik, Let me try to modify as suggested by you and if in case any issues i will alarm. Thanks, Suresh Kumar S

Hi Excel Heros, Any luck for my request. Thanks, Suresh Kumar S

Hi Excel Heros, As adviced by Luke i have created a workbook. Now i have 2 conditions and i have explained in the worksheet. Please provide the codes for 2 conditions. http://www.2shared.com/document/EWSdkMiI/schedule.html Thanks in advance, Suresh Kumar S

Thanks Luke for you valuable suggestion. I will work out if anythings goes wrong i will disturb you.