Search results

Hi, Can you please paste the below formula in E2. =INDEX($A$2:$D$9,MATCH(D2,$D$2:$D$9,0),3) Thanks, Suresh Kumar S

Hi, Can you please download the below file and check. http://www.2shared.com/file/1HY8qZOZ/rank.html Thanks, Suresh Kumar S

Hi Rob, Press Alt+F11 to view the macro code on the left side you can see VBAProject (1.xls) below that sheet1(sheet1), thisworkbook and modules. Double click the sheet1 you can find the macro codes for both command button copy those code and paste it in your workbook (paste the code to the...

Hi Rob, Can you please download the below and check. http://www.2shared.com/document/CIC0VQwR/1_online.html Thanks, Suresh Kumar S

Hi, Can you please refer the below link. http://office.microsoft.com/en-us/excel-help/display-or-hide-formulas-HP005199811.aspx Thanks, Suresh Kumar S

Hi Ram, Thanks for you feedback and I am in learning curve only. You can use Luke & shrivallabha code which is advanced level. To Luke & shrivallabha, I have been trained the macro code like step by step (i.e,Selection) and now I have learnt the single line (skipping Selection)...

Hi Ram, Please try the below code: Sub Macro1() ' ' Macro1 Macro Worksheets("Sheet2").Select Range("A2:F2").Select Selection.Copy Worksheets("Sheet1").Select Range("A65536").Select Selection.End(xlUp).Select Selection.Offset(1, 0).Select ActiveSheet.Paste End Sub Thanks, Suresh...

Thanks Hui

Hi, I have sheet of file size 34 mb. As per the request I have to copy 70 cells and paste for 2,00,000 cells.(I am able to perform the copy and paste the formula for max of 1000 rows only - due to some restriction in excel). After pasting formulas in all the 2,00,000 cells the file size has...

Glad to help Mr.Andrew, It can be done through Unique or remove duplicates (Under Data menu). I have used Remove Duplicates with help of Macro to have only unique ids. (Copy the entire column (rawdata) and paste in the next sheet and select entire column and choose remove duplicates under...

Thanks to all

Hi, Insert a module and paste the below code Sub copypaste() Worksheets("invoice").Select Range("d10:d20").Select Selection.Copy Worksheets("reports").Select Range("a1").Select Selection.PasteSpecial xlPasteValues Application.CutCopyMode = False End Sub Thanks, Suresh Kumar S

Thanks SirJB7.

Hi, Assume your data A3=09:00:00 A4 =10:45:00 A5=IF(A3<A4,A4-A3," ") (It will show blank when people are came in time or before and it will calculate only if any one came late) Thanks, Suresh Kumar S

Hi Herath7, You want macro to update the workbook? If so can you please upload the same workbook. Thanks, Suresh Kumar S

Thanks T100, I thought some other char-key will be there for ~ .

Thanks shrivallabha, where i can find the ~ on keyboard.

Hi, As already said by Excel Hero Narayan. your formula is correct apart from the below (TAX) and also can you please download the below file and check i have modified the data to get the output. =INDEX($F$2:$F$153,MATCH(I2&J2&K2&L2,$A$2:$A$153&$B$2:$B$153&$C$2:$C$153&$D$2:$D$153,0))...

Hi, I have list of years and i want to remove * special character alone from the list. Source: 2009 2010* 2011* 2012 Output: 2009 2010 2011 2012 Thanks, Suresh Kumar S

Thanks Deb, My work is done. Suresh Kumar S

Hi, I have list on Column A say 1 5 1 4 2 I want output as 1 5 4 2 Thanks, Suresh Kumar S

Thanks Debraj Roy (I Gained a new formula)

Hi Andrew, Can you please download the below file and check whether you looking this kind of output. http://www.2shared.com/file/kRfEK3H4/u_online.html Note:Only Unique records are moved without links. Thanks, Suresh Kumar S

Hi, Assume your data from A to C column. On E Column paste region (East,west,north & south) & F column paste the below formula and drag =SUMIFS($C$2:$C$20,$A$2:$A$20,$E2) Region Sales East 10579 west 8743 North 24771 South 53925 Thanks, Suresh Kumar S

Thanks Anupam Tiwari & Kris