Search results

@Hussein Welcome To Chandoo.org Forum, Glad you are here before post a question please read the Forum Rules from here and always try to post a sample workbook with desire request http://chandoo.org/forum/forums/new-users-please-start-here.14/ now come to your point you want use the formula...

Glad Your Problem Solve

My Hearty Congrats Bro on your achieve of 2k Milestone Keep Running Cheers

@deb Thanks for your input, off course i know this but the OP has to understand how that will happen with out errors / Zero Values, other wise he stuck in there :eek::oops: ???? Thanks SP

@ajaar Welcome to Chandoo.org Forum, Glad You Are Here This Forum is 24 X 7 and here every member will try to learn and try to solve the problems if any problem the Forum has beautiful Excel Ninja's and they can help To understand better about This Forum then please check the below link...

@deb i need some information about your file that is when i follow the instruction by you then the blank columns are blank in the next column but when i try the same thing new file then i am getting Jan 1900 how it is happen did you give any other formats for that because when i try the same...

@uday add the below code into your UserForm Module Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hwnd As Long, ByVal...

@Seahorse As per SirJB7 point out the result is coming 3 if we use the SirJB Formula If we use this then your required result is coming let's try =COUNTIFS($A$2:$A$8,"Refurb",$C$2:$C$8,"None",$B$2:$B$8,"<="&TODAY()) if any problem please inform Thanks SP

@uday another way just add the one more line in the commandbutton that is UserForm1.Show vbModeless we can do anything with excel file when the UserForm is Activate too Thanks SP

@Jeo In your Sheet1 Tab Column AZ is text format and you have to convert it as Number format so first select the AZ2:AZ17 and right click of mouse button and select the format cells then go to Custom and 000 digits in the Type when you enter in the Range AZ2:AZ17 = 1 / 2 then it will appear...

Narayan Sir My Hearty Congrats on Your 7k Milestone, please keep guiding us

@SANTHOSH Please Follow the Below Instruction : 1. Open your file 2. Press Alt +F11 3. In the Insert option select Module 4. Copy the Given Code and paste it 5. Close the VBA Project Window 6. Now press the Alt +F8 and run the code Hope it clear Thanks SP Note: Due to Net problem my...

@krispar Please Check this link may be it will help full http://www.extendoffice.com/documents/excel/1184-excel-merge-multiple-worksheets-into-one.html if any issue then please inform us Thanks SP

@milankumarsahu Welcome to Chandoo.org Forum, Glad you are here as per Vijay said may be it is Pivot Table if it is not please upload a sample file Thanks SP

@Ashis i have add a extra code for protect and unprotect in the code of Hui Please Download the file and inform us if any issue Thanks SP

@Anu I am not sure what you are trying exact but as per my understand you want to max date of a name or item then try this Array formula (Ctrl+Shift+Enter) in H2= =IFERROR(INDEX($C$2:$C$38,MATCH(MAX(($C$2:$C$38)*($B$2:$B$38=$G2)),$C$2:$C$38,0)),"") hope it solve your problem other wise...

@Some my hearty Congrats to became a Ninja keep it up SP

My Hearty Congrats to Hui (My Guru) to achieve your 6k Milestone Congrats, Please keep guiding us

@Anu you can use the below formula in GM Tab for getting the list of Sr. No. from Revenue Tab A2: =IFERROR(INDEX(Sr_No,MATCH(0,COUNTIF(A$1:$A1,Sr_No)+IF(COUNTIF(Sr_No,Sr_No)>1,0,1),0)),"") enter with array Formula as Ctrl+Shift+Enter Sr_No is named range hope it's solve other wise please...

@deb bhai moro idea re tume nuva subject jani golle kano osubidha jaha helle be setha tumo pain bhollona (Bro what is the problem if you learn the new subject i think it is best for you) Thanks SP

@Afarag Try the below Formula =TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,")",""),".",""),FIND(":",A1)-5,FIND(":",REPLACE(A1,99,FIND(":",A1),""))-1)) if any problem please let us know Thanks

@majedix i already explain how to hide / unhide the active sheet in my before post as per your request say your 4 sheets 1 is Master and rest is work sheets in the Master sheet insert 3 Command Buttons and place the Below mention code for each command button Private Sub...

@majedix Welcome to Chandoo.org forum, Glad You Are here please elaborate some more details what do you want

@Afarag when you use the Color Function from the Ozgrid then you have mention the Color in the Column $c$1 then it will count the Given Color of C1 Hope it's clear other wise please inform Thanks

@Prashant Kenia Welcome Chandoo.org Forum, Glad you are here as a new member first i would like to remember you please read before post any question in this forum about the forum rules from this link http://chandoo.org/forum/forums/new-users-please-start-here.14/ and most important is this...