$$Excel-Macros$$ excel subvalidation

dear champs, any one provide the sub validations formula enclosed the attachement. -- Regards, Shivaprasad K. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discus

$$Excel-Macros$$ Retrieve data

hi champs, i have one main sheet & some data sheet, i need two dates with time between the the formula retrive the main sheet based on Name colum in yellow color hilighted pl z fin example sheet. -- Regards, Shiva. -- Join official Facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Formula

Above Tat",IF(C2=2," In Progress not > completed",IF(C2=7,"Above tat in progess,not complete",IF(C2=0,"NA") > > > On Sat, Jan 12, 2013 at 12:02 PM, Shiva Prasad > wrote: > >> >> Dear Champs, >> >> please find the atta

$$Excel-Macros$$ Formula

Dear Champs, please find the attachment of example sheet, any one help me the formula of tat related. , Shivaprasad K. +91-9866351016 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Conditional format & formula

plz provide any one this solution. On Thu, Jan 10, 2013 at 11:39 AM, Shiva Prasad wrote: > Dear Champs, > > i need one excel formula help tat with conditional format & formula. > > > i tried if and if error but mistake but exact values are not received. > plz any one

$$Excel-Macros$$ Conditional format & formula

Dear Champs, i need one excel formula help tat with conditional format & formula. i tried if and if error but mistake but exact values are not received. plz any one help me please find the example sheet. need urgent any one plz help me. -- Regards, Shiva -- Join official Facebook page

Re: $$Excel-Macros$$ required the working hours calc(8 a.m to 8p.m)

659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shiva Prasad > *Sent:* 29 December 2012 2:40 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ required the working h

$$Excel-Macros$$ required the working hours calc(8 a.m to 8p.m)

Dear champs, please find the attachment of excel sheet, any one provide the formula for the working hours time calculation between the two dates with hours, needful -- Regards, Shivaprasad K. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

$$Excel-Macros$$ create a macro in pivot table

dear champs, how to create a macro in any 2010 excel pivot table -- Regards, Shivaprasad K. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

$$Excel-Macros$$ create macro pivot chart & report generation

Dear champs, i need help create a macro any report & after pivot i have to click command button to generate the report. plz help me need full -- Regards, Shivaprasad K. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, ac

$$Excel-Macros$$ Conditional formatting

Dear Champs, i have on excel one sheet when i mentioned values of percentages change the color of that cells. please help me the formula r any macro also. plz find the attchement of example of trail sheet. plz need . -- Regards, Shivaprasad K. -- Join official facebook page of this fo

Re: $$Excel-Macros$$ request to separate the no

hi ashsih koul, it is working very thanks , regards, shivaprasad. On Fri, Oct 19, 2012 at 9:16 PM, ashish koul wrote: > check the attachment see if it helps > > > On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad > wrote: > >> hi ashish koul, >> >> p

Re: $$Excel-Macros$$ request to separate the no

Fri, Oct 19, 2012 at 9:01 PM, Shiva Prasad > wrote: > >> hi ashish koul, >> >> please provide the example attachment. >> >> >> regards, >> shivaprasad. >> >> >> On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote: >> &g

Re: $$Excel-Macros$$ request to separate the no

1)) Then > a = a & Mid(x, i, 1) > End If > Next i > numeric_value = a > End Function > > > > On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad > wrote: > >> hi experts, >> >> how to separate the number, >> i mentioned in excel cell >> p

$$Excel-Macros$$ request to separate the no

hi experts, how to separate the number, i mentioned in excel cell please help me *example asdfhfgh9825101236sdfge, 9855255689dffhjrr * i want only number, can any one provide the macro. regards, shivaprasad. -- Regards, Shivaprasad K. +91-9866351016 -- Join official facebook page of

Re: $$Excel-Macros$$ Best wishes of festival : Ganesh Chathurthi

Thank u wish you same team On Sep 19, 2012 10:36 AM, "Vabz" wrote: > Hi All Champs, > > I wish you all happy & blessed Ganesh Chathurthi.. > > > > > > > Stay blessed & Keep Rocking alwayz.. > > Cheerz.. > > Rgds//Vabs >

$$Excel-Macros$$ Excel vba

hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops in excel VBA I want to learn excel vba , could any one give help me -- Regards, Shivaprasad K. -- Join official facebook page of this forum @ https://www.facebook.com/discussex