if i put a5 = a then ???????????????? On Mon, Aug 1, 2011 at 2:27 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote:
> * * > > *See the attached FIle* > > *=SUM(($B$4:$B$20=E4)*$A$4:$A$20)* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Kandade, Nitesh > *Sent:* Monday, August 01, 2011 1:37 PM > > *To:* 'excel-macros@googlegroups.com' > *Subject:* RE: $$Excel-Macros$$ Need Formula**** > > ** ** > > Hi,**** > > Here is the solution.**** > > ** ** > > * * > > * * > > * * > > * * > > * * > > *Thanks & Regards,*** > > *Nitesh Kandade***** > > Jr. Analyst**** > > OneWest Bank, FSB**** > > Office: (213) 337-3653 Ext.: 68361**** > > *n*itesh.kand...@owb.com <nitesh.kand...@owb.com>**** > > ** ** > > **** > > *This message contains information which may be confidential and > privileged.***** > > *Unless you are the addressee (or authorized to receive for the > addressee), ***** > > *you may not use, copy or disclose to anyone the message or any > information***** > > *contained in the message. If you have received the message in > error, please***** > > *let the sender know and delete the message. Thank you***** > > ** ** > ------------------------------ > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jocky Beta > *Sent:* Monday, August 01, 2011 12:46 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need Formula**** > > ** ** > > ** ** > > Hi Team,**** > > ** ** > > I have one sheet in which Two Columns are there in which first Column > there is Employee id and employee name. In Second column i need the exact > employee id as per there names. Hence pls tell me formula for the same.*** > * > > ** ** > > Please find the attached sheet for your Reference.**** > > ** ** > > ** ** > > Regards,**** > > ** ** > > ** ** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > 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**** > > -- > > ---------------------------------------------------------------------------------- > 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
