Search results

Hi @bushvilla In Sheet "My Database Page", In C8, you can use formula as.. =INDEX($D$13:$D$55,INDEX(MATCH(C6&DATEVALUE(C4),B13:B55&C13:C55,0),,)) and in C10, use formula as.. =INDEX($E$13:$E$55,INDEX(MATCH(C6&DATEVALUE(C4),B13:B55&C13:C55,0),,)) PS.. If you have already grip on ARRAY...

Did you tried... =CEILING(A1,10) =ROUNDUP(A1,-1)

xlsx are designed to work without macro.. To use the macro.. you must have to save it in any Programming enable format.. like "macro Enable Workbook (.xlsm)" or "Binary Workbook (.xlsb)" otherwise you will loose the Programming facility..

Hi Sk.. very difficult to get the scenario.. you want..:( Can you please post a sample file with expected output..

Simply you can book one cell to store last user name, and fetch the name from there.. at user_Form_initialize.. But if you are really looking for.. * Store a key in regedit, and and read the same at startup.. * Different for each System / User .. according to Prefech directory.. Then, you...

Or may be like this.. =IF(G2="","",IF(G2<100,1,IF(G2>=111,3,2)))

Hi Asish.. From Excel Help Section.. :)

Hi.. for more detail, you can visit here.. :) http://www.officetooltips.com/excel/tips/creating_a_glossy_thermometer_chart.html

Hi Carlen, Welcome to the forum. Please before posting, spend some time here.. http://chandoo.org/forum/forums/new-users-please-start-here.14/ with A sample file, you may got better answer..

Did you tried this.. With ws .AutoFilterMode = False .Range("A1", Cells(lRow, lCol)).Cells.AutoFilter .Range("A1", Cells(lRow, lCol)).Cells.AutoFilter Field:=cNumber, Operator:=xlFilterNoFill .UsedRange.Offset(1...

Can you please upload one more PICTURE, like this.. Click on the view tab, Freeze Panes, then Print Screen.. :) Or press Alt + W + F + F

Hi Jack.. * Press Ctrl + F1 Specially to hide Ribbon, when you clicked on on any Ribbon Menu, it re-appear (temporarily) and gives a floated look, which hides the Column Section.. a shaded layer on the Ribbon, shows that.. ribbon is hidden and showing temporarily..

Hi Shahul.. You are in the right track.. ;) just a lil modification.. :) Sub sumsheets() Dim ssum As Double For j = 2 To ActiveWorkbook.Sheets.Count Sheets("output").Range("B2").Value = Sheets("output").Range("B2").Value + WorksheetFunction.Sum(Worksheets(j).Range("B2:B2")) Next j End Sub...

Hi AHC.. Welcome to the forum.. check this one.. with step by step .. picture.. Let us know.. if you need some more better approach.. like @Somendra Misra 's approach.. :) http://www.wikihow.com/Add-Data-to-a-Pivot-Table

Congrats.. buddy.. @Somendra Misra Thanks for all support & effort to this forum.. Congratulation Debraj For completing 1year as a Ninja.. :) http://chandoo.org/forum/threads/congratulations-debraj-excel-ninja.10622/ PS: @myself.. work hard.. you are too slow.. :(

. Hi Somu.. Just a side note.. :) SUMIF/S, COUNTIF/S.. are enough capable to handle Full Columns range.. Internally.. its only checks data in Intersect of UsedRange & Provided Range.. :)

Hi 26830268 Chart Paste Special is just a short cut to Add Series/Value in Rows/Column, in a chart.. If you Google for.. "Automate Bubble Chart", you will find that code to add Series or values Collection.. PS: By seeing 224*214 pixel image.. I think, above two lines are enough for the time...

Hi anamika.. Welcome back.. and thanks for sharing feedback.. (Its better to be late, than never.. :))

Hi Renganathan.. I guess. You are looking for Loop within ARRAY.. but backward & Cyclick.. Can you please check the below code.. Sub test() Dim MyArray() As Variant 'MyArray = Array("1", "2", "3", "4", "5", "6") NoOfArray = InputBox("Enter No of Array in MyArray", , 6) - 1...

Hi Villalobos Tested and working fine.. in 2013.. Its giving chance to go to File Menu.. displaying Startup Screen.. But .. click on Folder / Drive / Shared Location, is not working (as expected).. Its blocking just "Save As" Dialog box..

Hi Villalobos I have read somewhere.. excel 2013 has Two types of SAVE AS method. One using Alt + F + A using Save As Dialog Box. Another is though File menu.. Then Startup Screen > Then selecting your desired location (Skydrive / SharePoint / Computer) then Save as.. Using second option, its...

Hi Jafa.. Welcome to the forum.. :) Here is a cheated method.. Actually what you are trying.. is mixing two different set of axis in a single plot.. I hope, someone will come with a better approach.. :(

Closed as Duplicate

Here is another method.. =SUM(IF(B2:B7=H8,1/COUNTIFS(C2:C7,C2:C7,B2:B7,H8)))

OOPS.. Nice catch.. @Somendra Misra