Re: $$Excel-Macros$$ Help Required on Conditional Formating
Thanks On 7 Mar 2015 14:46, "Vaibhav Joshi" wrote: > Hi > > check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/ > > Cheers!! > > On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta > wrote: > >> Dear Friedns, >> >> Kindly help me in creating a conditional formating calander just like >> goole calander. >> >> My basis needs are as follows:- >> >> >> 1. Start Date >> 2. End Date >> 3. Days of Week( Could be Sunday to Monday any) >> 4. Start time of Class >> 5. End time of Class >> >> This could be for many teachers. >> >> Depending on condition I need a calander which could get color >> fomatted as soon we input our above said criteria. Kindly help me on >> this >> >> Sample file attached. >> >> Thanks >> Mukesh >> >> -- >> 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/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Help Required on Conditional Formating
Dear Friedns, Kindly help me in creating a conditional formating calander just like goole calander. My basis needs are as follows:- 1. Start Date 2. End Date 3. Days of Week( Could be Sunday to Monday any) 4. Start time of Class 5. End time of Class This could be for many teachers. Depending on condition I need a calander which could get color fomatted as soon we input our above said criteria. Kindly help me on this Sample file attached. Thanks Mukesh -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Time_Test.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Vlookup against the value generated from formula
Dear Subhash, You need to use trim command on group code in both sheets...your problem will be resolved. ...Still if you are not able to handle do revert. Regards Mukesh Gupta On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav wrote: > When I m trying to use to formula VLOOKUP against any formula generated > value, there is error. > > Please suggest suitable method for the same, as I have to take many of the > value based n these types of conditions. > > Sample file attached. > > > -- > Subhash Chand Yadav > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Subtract the minimum value based on multiple criteria
Dear Friend, You just need to use the following formula A B C D CityCarrier Total Diff Albertville A 700.00 In the D field type =C3-$C$3 and just copy and paste this to remaining below in the Diff field. Do revert for further clarification. Regards Mukesh Gupta On Thu, Aug 4, 2011 at 9:54 PM, dewbro2 wrote: > I have a worksheet that tracks rates for multiple lanes by multiple > carriers. I am trying to find an easy way to calculate the difference > between the rate for each carrier on a lane and the lowest rate for a > given lane. I am spending a lot of time manually correcting formulas, > and I would like to have 1 formula that I can copy throughout the > worksheet. Example: Where the City is Albertville, the lowest rated > lane is Carrier A at $700 dollars, so I want the value of "zero" in > the "Diff" field (=sum(C1-C1)). However for Carrier E for the > Albertville lane, I want a value of 536.50 in the "Diff" field which > is the difference between the rate in cell C6 and the minimum rate in > cell C1. I will need to do this for every carrier/lane in my > worksheet and there are thousands of these entries. Hope this makes > sense. Any solutions would be GREATLY appreciated. > > ROW/COL A B C D > 1 CityCarrier Total Diff > 2 Albertville A 700.00 0.00 > 3 Albertville B 725.00 25.00 > 4 Albertville C 728.00 28.00 > 5 Albertville D 750.00 50.00 > 6 Albertville E 1,236.50536.50 > 7 Albertville F 1,323.11623.11 > 8 Albertville G 1,374.75674.75 > 9 Albertville H 1,834.751,134.75 > 10 BessemerA 500.00 0.00 > 11 BessemerB 525.00 25.00 > 12 BessemerC 550.00 50.00 > 13 BessemerD 560.00 60.00 > 14 BessemerE 570.00 70.00 > 15 BessemerF 700.00 200.00 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel