Search results

Hi, Change your formula with constant by pressing F2 then press F4 on each reference. =IF($A$834<>"",COUNTIF($A$2:$A$834,$A$834)&" OF "&COUNTIF([ItemNo],$A$834),"") Thanks, Suresh Kumar S

Thanks Jason, Deb & SP.

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

Hi, I have data in column A with header called Income below that lot of numbers there. i want to add those numbers. i tried sumif and sumifs also but no use. please help me Thanks, Suresh Kumar S

Hi, I have workbook of 5 worksheets and all worksheets contains some formulas. I want to highlight if any other worksheet is linked with active sheet. Example in Sheet1.A1 =B1+Sheet2!B1 in this case is it possible to highlight either by macro or conditional format or some other tricks...

Hi, Assume your data in A1 and paste the following formula in B1 =TEXT(A1,"MM DD YYYY") Thanks, Suresh Kumar S

Hi, Use Conditional format. Can you please refer the below links it will help you to learn conditional format. http://chandoo.org/wp/excel-tutorial/using-conditional-formatting/ http://www.exceltraining.org.uk/excel-2007-2010-conditional-formatting-tutorial Thanks, Suresh Kumar S

Thanks Deb for your response.

Hi Ausipeet, You can also refer the below links for VLOOKUP Forumla. If you go through the below links it will help you to know how vlookup is working. http://chandoo.org/wp/2010/11/01/vlookup-excel-formula/ http://www.free-training-tutorial.com/function-vlookup.html Thanks, Suresh Kumar S

Hi Ausipeet, You can also refer the below link for VLOOKUP Forumla. http://chandoo.org/wp/2010/11/01/vlookup-excel-formula/ http://www.free-training-tutorial.com/function-vlookup.html Thanks, Suresh Kumar S

Hi, Can you please check the below link i have modified some fileds to get the output(Highligted Yellow) http://www.2shared.com/file/XYUwi2MH/1_online.html Thanks, Suresh Kumar S

Thanks Deb is it possbile with macro?

Hi, I have a set of data in sheet1 and sheet2 by using Trace Precedents is it possible to figure out all the cells in both the sheets. Example i have formula in sheet1 on E4 = E3+Sheet2!E3. Now by using Trace Precedents i am able to find out the E3 (sheets1) cells but it is not selecting...

You have to select each column and change the colour.

Hi, Can you please check the below link. http://www.contextures.com/excel-pivot-table-calculated-field.html Thanks, Suresh Kumar S

Thanks Oldchippy & Shrivallabha is it possible to add $ (Absolute Reference) with the help of vba.

Hi, I have some formula without String ($) now i want replace the formula with string function. Suppose A1 =C1+D1 i want A1 = $C$1+$D$1 Thanks, Suresh Kumar S

Hi, Create a new module and paste the below code it will work. Sub hideorunhide() If Range("c2").Value = "NONE" Then Rows("8:10").EntireRow.Hidden = False Range("c2").Select ElseIf Range("c2").Value = "MAX" Then Rows("8:10").EntireRow.Hidden = True Range("c2").Select ElseIf...

All credit goes to Narayan (Excel Ninja)

yes and its working correctly.

Hi, Can you please upload the same workbook. http://chandoo.org/forums/topic/posting-a-sample-workbook Thanks, Suresh Kumar S

Hi, Can you please download the below file and chekc. http://www.2shared.com/file/GWHYhhEX/M_online.html Thanks, Suresh Kumar S

Hi Ananthram, As per Narayank code its working perfectly. Please download the below file and check http://www.2shared.com/file/QpWM6klU/q_1_.html Thanks, Suresh Kumar S

Thanks Naryan. I will try and get back to you

Hi Narayan thank you very much for your vba code. One more question without giving the name range,is it possbile to compare with A1 & AA1 formulas and it should highlight likewise till A3 Thanks, Suresh Kumar S