Re: $$Excel-Macros$$ Need Help
Hi Se att, u can do with pivot table. Rgds Enjoy excelling... On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose wrote: > Dear Team, > > Please find attach file in which i have explained my requirement and > request of your kindness to provide me the solution, *as i have more than > 4000 records of such data*. > > Thanks & Regards > Priya > > -- > > -- > 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 Solution Quest.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Query
Dear Amir, Pl provide more clarity wid complete example. http://www.signaturebar.com/>http://www.signaturebar.com/uploads/images/24667.png border=0> On Tue, Jan 18, 2011 at 12:01 AM, Aamir Shahzad wrote: > Dear experts, > > > > How to resolved attached query, can anybody tell formula not macro. > > > > Regards, > > > > Aamir Shahzad > > -- > > -- > 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$$ If condition limitation.
PFA Sample Data, if we can do with formula or vba both option is welcome. Rgds Vaibhav On Tue, Aug 28, 2012 at 11:34 PM, wrote: > Hi All > > I have a tracker with almost 10 condition to be tasted. All condition is > shown as header, for case 1 when first event is completed then date of > completion is put under 1st header and under status for case 1 value to be > reflected is description of header 1. > > When second event is completed then under header 2 date of completion is > mention and status is replaced with description of header 2 and so on. > > So in column A all event name is mentioned, col B is status col. And from > column C to column L header 1 to 10 is mentioned. > > Eg. Value of cell A2 is Case North Port and now description of column C to > Z header is START, EMAIL SENT, REPLY recd and so on. > > So when case is logged in date is mention under START header i.e. In cell. > C2 we put date of email sent. So status in Cell B2 will show as START. > > Now when email is sent cell D2 will be updated with date of email sent and > Cell B2 should show status as Email Sent. > > I tried applyin if condition since we are using excell 2003 not more than > 7 nesting of if is used. > > Any alternate way out for the same. > > Rgds > Vaibhav. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. TRACKER.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ If condition limitation.
Hi Don, This work on logic that this formulae returns nearest max vaue to -1 that is cell refering to highest date. If i want this to return cell refering to lowest date then how can we et it. Rgds Vaibhav On Wed, Aug 29, 2012 at 7:07 PM, dguillett1 wrote: > =IF(ISNA(MATCH(1,2:2,-1)),"",INDEX($1:$1,0,MATCH(1,2:2,-1))) > copy down > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* mailto:in.vaib...@gmail.com > *Sent:* Tuesday, August 28, 2012 11:51 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ If condition limitation. > > PFA Sample Data, if we can do with formula or vba both option is welcome. > Rgds > Vaibhav > On Tue, Aug 28, 2012 at 11:34 PM, wrote: > >> Hi All >> >> I have a tracker with almost 10 condition to be tasted. All condition is >> shown as header, for case 1 when first event is completed then date of >> completion is put under 1st header and under status for case 1 value to be >> reflected is description of header 1. >> >> When second event is completed then under header 2 date of completion is >> mention and status is replaced with description of header 2 and so on. >> >> So in column A all event name is mentioned, col B is status col. And >> from column C to column L header 1 to 10 is mentioned. >> >> Eg. Value of cell A2 is Case North Port and now description of column C >> to Z header is START, EMAIL SENT, REPLY recd and so on. >> >> So when case is logged in date is mention under START header i.e. In >> cell. C2 we put date of email sent. So status in Cell B2 will show as START. >> >> Now when email is sent cell D2 will be updated with date of email sent >> and Cell B2 should show status as Email Sent. >> >> I tried applyin if condition since we are using excell 2003 not more than >> 7 nesting of if is used. >> >> Any alternate way out for the same. >> >> Rgds >> Vaibhav. >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> mailto:excel-macros%2bunsubscr...@googlegroups.com >> . >> >> >> > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum
Re: $$Excel-Macros$$ Need Suggestion urgent
Hi, I am working on it. Will send you by tomorrow. Thanks for waiting. On Thu, Nov 25, 2010 at 10:03 AM, Ankit Agrawal wrote: > Sir ji, > > I think it does not have any solution that why no body given any ans.or any > solution. > > > -- Forwarded message -- > From: Ankit Agrawal > Date: Tue, Nov 23, 2010 at 11:19 AM > Subject: Re: $$Excel-Macros$$ Need Suggestion urgent > To: Deepak Rai > Cc: excel-macros@googlegroups.com > > > Thank you sir ji > > but I have again problem that my data in excel and I prepare documents > separately as I attached file in my last mail.I need a system which send > mail to all employee directly and file also content the their PAN as > password. > > Is it possible or not? Please kindly suggest me.I have to prepare this > month salary.if it will be done than I would get increment and I will sure > spent first month increment on you all. > > Thanks & Regards > Ankit Agrawal > > > On Mon, Nov 22, 2010 at 11:58 PM, Deepak Rai wrote: > >> Hi Ankit, >> >> Basically few times back I was also got stuck with this problem. As I am >> good in VBA I customized the attached file as per my need. If you can also >> customized the attached file really trust me you will feel out of the world >> by knowing its power. I use the attached code in my all project where in I >> require to send mails to all users. >> >> Hope this will help you. :) >> >> Regards, >> Deepak Rai >> >> On Mon, Nov 22, 2010 at 2:16 PM, Ankit Agrawal < >> ankit.agrawal...@gmail.com> wrote: >> >>> Dear All, >>> >>> I did not get any solution from your side so it mean it does not have >>> solution or no body knows about it. >>> >>> at least any body can give any suggestion on it >>> >>> On Tue, Nov 16, 2010 at 6:53 PM, Ankit Agrawal < >>> ankit.agrawal...@gmail.com> wrote: >>> Hello Sir, I have a problem related to mail through excel. basically I have to make salary slip. and forward it to the employees. I manage the data into the excel and use mail merge in MS word. now the problem is, I have to make separate file for each employee and have to send one by one on their e-mail id. Question 1- Is any way that we can make separately file automatically and send to it mail automatically to each employee. 2- is any way that every file having its own password and its password would be employee DOB or their PAN may be any other key Here I am sending you sample file so please illustrate it because I am new in the excel and don't know much more about other computer software & tools Thanks & regards Ankit -- -- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >>> >>> -- >>> >>> -- >>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >>> >> >> >> >> -- >> Regards, >> Deepak Rai >> >> > > -- > > -- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Dear Rahul Pl explain the procedure, if you are saying you will be sending it to 9000, then will you be using mail merge or not. If not how u will be sending (i.e. using which application) to 9000 employees. Rgds Vaibhav J On Tue, Nov 30, 2010 at 9:21 AM, Rahul Gandhi. wrote: > Sir, > > Thanks for the prompt action, But I have a Data of 9000 Employees. > > I have to Send the Letters to Employees without using the Mail Merge. > > Only with The Hlp of Concatenate. > > Eg. > > ="Your Salary is increased with Rs. "&A1&"/- Please find enclosed > attachment which contains the breakup of amount" > > What actually I want is the Value which is derived from A1 should be > Bold. > > > Thanks. > Rahul Gandhi > > On Nov 28, 9:37 pm, Dilip Pandey wrote: > > Hi Rahul, > > > > I dont think there is any existing function using which you can bold > > at text. Considering your problem, I have thought of one smart way :- > > let say A1 has the text which needs to be bold. Go to B1 and type the > > formula =a1. Now apply conditional formatting in B1 that if cell B1 is > > not blank, then text should be bold. (=not(isblank(b1)) :) > > > > Best Regards, > > DILIPandey > > > > On 11/28/10, Rahul Kamal Gandhi wrote: > > > > > > > > > Guys, Can anyone Help me to Bold the text with the help of Formula > > > > > Eg. > > > > > A1 Cell Contains "ABC" > > > > > I Want to write the formula in any cell, lets take Cell B1 > =AnyFormula(A1) > > > > > And My output should be *ABC* But in Bold Format > > > > > Any Formula or Code. Please Guys I am Struck > > > > > Regards, > > > Rahul Gandhi > > > +91-9711772297 > > > > > -- > > > > -- > > > 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 athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://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/pages/discussexcelcom/160307843985936?v=wall&;. > .. > > > > -- > > Sent from my mobile device > > > > Thanks & Regards, > > > > DILIP KUMAR PANDEY > > MBA-HR,B.Com(Hons),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 62, India > > -- > > -- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Queries
Hi, Try Sumproduct formula Rgds Vaibhavj On Sun, Nov 28, 2010 at 2:06 PM, neil johnson wrote: > Hi Everyone. > > I have large data in excel. for example in sheet 1. and we have name in > sheet 2 . I use vlookup function and fetch the production using vlookup . > now when i saw the total there is difference between two . When i see in the > sheet 1 . there is duplicate name as well as value is difference. can some > one explain how can we fetch the data by using small function + vlookup > function + offset function. of second value of harmeet. So total may be > similar. > > I have no complete idea about that . > > > Thanks > > -- > > -- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts Neil_Query.xls Description: MS-Excel spreadsheet
