Search results

Hi.. did you tried.. =TEXT(A1,"YYYYMM")

Hi gtothek! Thats secretly hidden in Pivot table.. :) whenever you will add more than one columns data in VALUES section.. by default.. VALUE section inserted in Column Section.. Give a try..

Hi Birinder.. Can you please upload a sample file.. Infact.. double click on any customer name .. will do the same for you.. extract the customer data for the same.. I know.. Pivot Table already have that feature to extract each customer's data separately.. Play with this feature.. no VBA...

Hi Somu.. Just for sharing purpose.. :) =INDEX(($A$2:$D$13,$A$16:$D$27,$A$30:$D$41),MATCH($H$8,$A$2:$A$13,0),COLUMN(B1),ROW(A1)) Index function also has a great rarely use parameter available.. :) with the help of perfect data structure in the above case.. you can use a single formula for...

WOW.. nice idea .. thanks for sharing.. :)

Hi Matt.. I tried atleast 4-5 times.. but not able to decrypt right now.. Still give a try.. ** Backup Registry strongly recommended Run > Regedit > HKEY_CURRENT USER > Control Panel > Desktop > WindowMetrics check for Binary ScrollWidth (if not found you can create Right Click > New >...

Hi hnd.. any sample file .. for your imagination .... are you talking about user form or excel sheet.. Dropdown with multiple choice.. I think.. List box & user form is required in this case..

Hi Vivek.. Click on "Clear filter from Client" & Clear Filter in Slicer section are same thing.. You cant set Clear filter in Slicer.. but not in Actual Pivot Table..

hi gtothek! Can you please upload a sample file.. with manual expected result.. I have a doubt on the Start Month structure.. Its may be just a TEXT. May be we can reduce the formula length if sample available..

Hi Prashant.. try this.. in c2 use formula as.. =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))

Hi Nipendra, I copied the code form Debra's site.. I think, that' the actual origination of this technique. I Just added a single line.. Please check the attached.. Option Explicit ' Developed by Contextures Inc. ' www.contextures.com Private Sub Worksheet_Change(ByVal Target As Range) Dim...

Can you post a sample file.. with detail explanation.. please..

Hi Vivek.. Close Months are actually TEXT, not DATE.. In the pivot table Add Close Date in Rows Section.. (just for a while..) In the Row label section.. GROUP "CloseDate" with Month. Now remove the Close Date from the ROW Section.. Now Insert Slicer.. for Close Date.. You dont need those...

Welcome mikelowski.. Please check this one.. yes VBA approach.. hope you can manage to adapt it.. otherwise let us know.. http://chandoo.org/forum/threads/chart-conditional-formating.13780/

Hi Manish, I think, excel is giving you correct result.. Just you need to change the Number Format, so that you can view the actual output.. Try to convert result cell as "DD HH:MM:SS" or use below formula.. =TEXT(B1-A1,"DD hh:mm:ss")

or.. in A1.. =TEXT(TIME(0,ROW(),0),"h.mm")

Hi Melissa, Welcome to the forum. If you change a lil bit in your data, it will be lot easier for you.. check the attached.. Few basic changes has been done.. Let us know.. if this is working for you.. =INDEX(C10:H15,MATCH(D2,B10:B15,1),MATCH(D3,C9:H9,-1))

Hi Guna! Try this too.... =LOOKUP(2,1/ISNUMBER(SEARCH(ListOfNames,B2)),ListOfNames) Where listOfNames is range ($A$2:$A$4) from where you want to search for the test in a sentence.

Hi Kumar.. Did you tried.. * Copy the formula from C3. * paste the formula in anywhere.. except C3. What you are trying.. is copying and pasting the formula in same cell (or including the same cell) avoid it.. it will work.. infact.. you can drag also..

Hi Karthik.. Sorry.. as I was lil bit busy.. Can you please wait till weekend..

In case of software.. try.. It works well for me in most of the cases.. ABBYY FineReader

Hi karthik.. Check this one.. Click the shape to rotate.. Courtesy: http://www.mrexcel.com/forum/excel-questions/593944-visual-basic-applications-shape-rotation.html

Hi Shahul.. Is this what you are looking for.. Then go for.. Pivot table Wizard.. Multiple Consolidation Range.. Will elaborate.. if this is works for you..

Hi @paradise ! Can you please check the formula.. below.. Is this is correct way to decide "PayBack Period"!! I dont have any Financial knowledge.. :( In B9, use CSE Formula as.. ="Qtr " & MATCH(0,MMULT(N(TRANSPOSE(COLUMN(CashFlow))>=COLUMN(CashFlow)),TRANSPOSE(CashFlow)),1) Let us know.. if...

Without loop or structure of the macro, its hard to decide.. Can you please post a sample file with macro.. upload only few lines for debug..