Search results

@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...

@Gaurang Thanks for your kind words, welcome back if any problem Gaurang we all are learners and we can learn more from this forum Thanks

@Gaurang Mhatre ok Gaurang i think the file was corrupted when that uploaded please download the file again from this link https://dl.dropboxusercontent.com/u/75654703/Gaurang.xlsm if any issue let me know Thanks

Where is your Attachments !!!!

Thanks for your kind words Glad you solve it

@webmax Please Try this, say your amount in A1:A4 100000 500000 50000 1000000 in B1 = A1/100000 Then Copy and Drag Down Another Way put the Value 100000 in C1 copy it and select the range A1:A4 and past special and select divide option and ok, it is done if any problem please inform Thanks

@Afarag Hi, Please download the file i have set my previous codes only for All Tab Buttons rest tabs you can set if any problem please inform Thanks

@Gaurang Glad your problem solve, can you tell me what type of error you are getting from my file

@pratapkumar mohapatra Welcome to Chandoo.Forum, Glad you are here as a new member i would like to request please read the Forum Rules and before any question please search in Google or the Top right side of the Google Search...

@Gaurang Mhatre Hi, Have a look at this file may be it will help you if any problem please let us know Thanks

@Afarag Hi, May be the Hyperlink is not properly for the hidden sheets so please place the command button in Sheet1 and use the below code for hide and unhide the sheets Private Sub CommandButton1_Click() 'Unhide the active sheet and 'Goto to 'Sheet1' With ActiveWorkbook.Worksheets("Sheet2")...

@Wilco Hi, i think it is better to upload a sample file as per your requirement and may be one of our members and Ninja's can help you

@NARAYANK991 My Hearty Congrats for your 6k Mile stone Cheers and advance Happy New Year :DD Regards

@ram Please Check This file here is a New Tab named with Sgmpatnaik, if any issue please inform

@Abhijeet Please check this link may be it will help full to you other wise please inform http://www.ozgrid.com/forum/showthread.php?t=151803 Regards