Re: $$Excel-Macros$$ Pls Help me in the attached file
Thank you very much to group and specially to people who helped me
In this formula you have used Right Left function but in Right function u
have used 2 times minus sign can u explain this please.
Thanks Regards
Dharmesh Shah
On Fri, Mar 4, 2011 at 4:18 AM, siti Vi villager.g...@gmail.com wrote:
for your info only
-- Forwarded message --
From: STDEV(i) setiyowati.d...@gmail.com
Date: Fri, Mar 4, 2011 at 5:40 AM
Subject: Re: $$Excel-Macros$$ Pls Help me in the attached file
To: excel-macros@googlegroups.com
why not
=SUMPRODUCT(
('Closing Price'!$B$2:$B$3473=$A16)*
('Closing Price'!$D$2:$D$3473=LEFT(B$15,2))*
('Closing Price'!$E$2:$E$3473=--RIGHT(B$15,4))*
('Closing Price'!$K$2:$K$3473))
On Thu, Mar 3, 2011 at 4:32 PM, Dharmesh Shah dharmeshsha...@gmail.com
wrote:
Dear All
I want some specific value using formula or any other method.
Please help me to get the required answer.
Thanks Regards
Dharmesh Shah
--
--
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$$ income tax calculator
Thank you Nemi On Thu, Mar 3, 2011 at 12:01 PM, Nemi Gandhi nemigan...@gmail.com wrote: Sudhir vermaji, Attaached herewith income tax calculator in excel format. See if its useful? -- Nemi Gandhi 98204 92963 -- -- 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 -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisation works also. -- -- 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
Re: $$Excel-Macros$$ income tax calculator
thanx and if you will find it's update version please sent me. On 3 March 2011 08:31, Nemi Gandhi nemigan...@gmail.com wrote: Sudhir vermaji, Attaached herewith income tax calculator in excel format. See if its useful? -- Nemi Gandhi 98204 92963 -- -- 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 -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * *Happy **Valentine** Day * \ ¦ / (ò ó) _ ___o0o___(_)___o0o__ ___¦_¦_¦_¦_¦ ¦_¦_¦_¦_¦__ ___¦_¦_¦_¦_¦ *Drink Bear Save Water* * * -- -- 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: Fwd: $$Excel-Macros$$ new querry
Thanks all for solution. Nemi Gandhi On Mar 3, 3:10 pm, §»VIPER«§ viper@gmail.com wrote: Hi Ignore my previous mail. Now check the attachment and revert if it is not helpful. -- *Thanks Regards Thamu * On Wed, Mar 2, 2011 at 10:45 AM, Nemi Gandhi nemigan...@gmail.com wrote: attached again with explanation. -- Nemi Gandhi 98204 92963 -- -- 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/discussexcel * * -- *Thanks Regards Thamu * * * naksatra_solved new.xlsx 12KViewDownload -- -- 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$$ Open an Excel File into its own seperate window in Excel.
This is really great. And we need to know the options for %2 %3 also in the open parameters On Sun, Feb 27, 2011 at 10:18 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Susan, Seems to be interesting issue:- Two workarounds:- 1) Try closing the other Excel by key combination Ctrl + W. Also check what happens when you are pressing Alt + F4 2) Look out for the option Windows in Taskbar, it should be there in the Option dialogue box. (I am not familiar with Excel 2010, hence can't guide you exactly where is this option) Best Regards, DILIPandey On 2/27/11, Susan sunni...@gmail.com wrote: This isn't a Macro or VBA issue , it is a Windows XP, Excel 2010 file extension issue: Some time ago I found out and could configure Windows that will allow more than one Excel workbook to open up in its own Excel window. Today I cannot remember. nor can I find the How To instructions in the internet. I have one Excel workbook open and want to open another workbook so it will open in a separate Excel window. When I close the Excel file at the Excel Close box it only closes that file and not the other Excel file I have open. Can you send me the How To instructions? Below I did a print screen of where to change Excel, in Editing Action for Type: Microsoft Excel Worksheet. Description: cid:image001.jpg@01CBD5C9.84053E30 Susan -- -- 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,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/discussexcel -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to
Re: $$Excel-Macros$$ Problem on picking series in chart
I you hide the data columns , Excel Will not show those columns in the chart Excel Only shows the chart of visible columns and the filtered data On Sun, Feb 27, 2011 at 10:33 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Gaurav, I hv tried opening the attached file but it appears to be corrupted, please share the xls version of this file so that Group members can view the same. Best Regards, DILIPandey On 2/26/11, Gaurav Ahuja ga.iit...@gmail.com wrote: Hi All, I am trying to construct chart with series selected from a table with only selected series to be represented in chart. I tried using check-box for every series but the legend still reflects all the series (including not selected series). i Hope there is a better way to handle this. I have attached spreadsheet for reference (raw data and not with checkboxes). Please help. Thanks Gaurav -- -- 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 -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,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/discussexcel -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the
Re: $$Excel-Macros$$ Entry of more than 16 characters in a cell
Will that behave as number? that will behave as text then On Sat, Feb 26, 2011 at 8:57 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: XL has a specification limit of 15 decimal digits of precision (see Help, Specifications). There's nothing you can to in XL itself to extend the precision. There are a few add-ins around that you can Google that claim to give up to 200 decimal digits of precision, but I haven't tried any of them. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ashish Khandelwal *Sent:* Saturday, February 26, 2011 1:31 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Entry of more than 16 characters in a cell Hi friends, When I enter a 16 digit number in a cell, the last digit become 0. How can I enter a 16 or more digit number in a cell. Thanks Regards, Ashish. -- -- 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 -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes
Re: $$Excel-Macros$$ Help in Data validation
Hi find the attachment and revert if it is not what you want. -- *Thanks Regards Thamu * On Wed, Mar 2, 2011 at 11:54 AM, naresh v naresh.veerabo...@gmail.comwrote: Hi Rambabu, please find the solution.. Regards, Naresh V, Analyst Hyderabad. On Wed, Mar 2, 2011 at 3:08 AM, Vinod N nvino...@gmail.com wrote: Hi Rambabu, I was able to derive the result using formula but was unable to do the same through validation. PFA the stop-gap solution. Hope the solution is of some help to you... :) Thanks Vinod On Tue, Mar 1, 2011 at 5:31 PM, Rambabu Mudiraj rambabu1...@gmail.com wrote: Dear All, Can anybody help me on this validation problem -- Regards Rambabu. G -- -- 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 -- Thanks and Regards Vinod Narayanan -- -- 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 indirect Validation.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Report reconcile
And also the can we show the amt in difference column itself instead of 'NA' if it is as not found in report also. Regards, Kurikkal. On Fri, Mar 4, 2011 at 6:59 PM, kurikkal padinjarappalla padinjarappa...@gmail.com wrote: Dear Saurabh, Thank u very much!! It works great, Can we add one more feature in it, now it does not reflect the RefNo and amounts which are only in Report 2, so can we add this one also in solution as 'Not found in Report 1', Regards, Kurikkal. On Fri, Mar 4, 2011 at 7:22 AM, saurabh singh saurabh...@gmail.comwrote: Try dis cnt post 2 google grp no access -- Forwarded message -- From: Saurabh Singh saurabh.si...@evalueserve.com Date: Fri, 4 Mar 2011 08:09:41 +0530 Subject: FW: fff To: saurabh singh saurabh...@gmail.com Saurabh Singh _ Research Associate Investment Research II Evalueserve Tel : +91 124 4154200 Ext:2165 Mob : +91 9871971132 Fax : +91 124 4154195 www.evalueserve.comhttp://www.evalueserve.com/ From: Saurabh Singh Sent: Thursday, March 03, 2011 5:05 PM To: Saurabh Singh Subject: fff Saurabh Singh _ Research Associate Investment Research II Evalueserve Tel : +91 124 4154200 Ext:2165 Mob : +91 9871971132 Fax : +91 124 4154195 www.evalueserve.comhttp://www.evalueserve.com/ The information in this e-mail is the property of Evalueserve and is confidential and privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken in reliance on it is prohibited and will be unlawful. If you receive this message in error, please notify the sender immediately and delete all copies of this message. -- Thanks Saurabh Singh -- -- 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$$ Fwd: Help on formula
Ahh perfect it condenses the 4 conditions to at least 2, it´s still a little confusing for me to put formula into formulas and organize them. 1001 thanks Paul, Excellent as usual :) 2011/3/3 Paul Schreiner schreiner_p...@att.net I would use: =IF(IF(P3T3,1,0)+IF(Q3U3,1,0)+IF(R3V3,1,0)+IF(S3W3,1,0)=2,true,false) Paul -- *From:* Jorge Marques leote.w...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, March 3, 2011 4:39:26 AM *Subject:* $$Excel-Macros$$ Fwd: Help on formula Hi guys i need a help on a formula or at least a way to change what i was thinking with a formula or macro i have two years that i have to compare, 2009 and 2010, they are in quarters(Q1,Q2;Q3,Q4) i made a formula that gives true or false under this condition if at least 2 of 4 quarters of 2010 have lower values comparing to the same quarters of 2009 the formula gives true else false like if Q1 2009 Q1 2010 and so on, or(and(P3T3, Q3U3), and(Q3U3, R3V3...) and so on, is it really necessary to do all the possible combinations in this formula?thank you very much in advance I put in attach the excel file. 1000 thnks -- -- 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
Re: $$Excel-Macros$$ help with formating
Thanks Mate, its great From: STDEV(i) setiyowati.d...@gmail.com To: excel-macros@googlegroups.com Cc: pawel lupinski lupins...@yahoo.com Sent: Fri, March 4, 2011 6:31:35 PM Subject: Re: $$Excel-Macros$$ help with formating see inside if it help On Fri, Mar 4, 2011 at 8:33 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I realy need your help with formating of the cells. see inside. Thanks Pawel -- -- 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$$ help with formating
with conditional formatting you just have to change% for conditions 1,2,3 chilexcel 2011/3/4 pawel lupinski lupins...@yahoo.com Hi All, I realy need your help with formating of the cells. see inside. Thanks Pawel -- -- 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- 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 analiza_wyd_with conditional formatting.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Problem on picking series in chart
See attached file if it helps -- -- 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 Problem(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Help needed - Extract data by customer name
Hi Friends, I have row data in the sheet1, which contains multiple data entries for the same customer. I am trying to extract each customer data in separate sheet (Extract_Data) and at the same time calculating the average price sum of the total quantity shipped to the particular customer. When I enter any new data in the sheet1, Extract_Data sheet should update automatically. If there is a new customer entry than also the extract data sheet should get update automatically with the new customer data. I have attached the reference sheet. 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 Extract_Data_By_Customer_Name.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pls Help me in the attached file
Hi dharmesh
simply it will convert text (which numbers in text formats) to values.
equivalent to (value) function.
--
*Thanks Regards
Thamu
*
On Fri, Mar 4, 2011 at 10:52 AM, Dharmesh Shah dharmeshsha...@gmail.comwrote:
Thank you very much to group and specially to people who helped me
In this formula you have used Right Left function but in Right function u
have used 2 times minus sign can u explain this please.
Thanks Regards
Dharmesh Shah
On Fri, Mar 4, 2011 at 4:18 AM, siti Vi villager.g...@gmail.com wrote:
for your info only
-- Forwarded message --
From: STDEV(i) setiyowati.d...@gmail.com
Date: Fri, Mar 4, 2011 at 5:40 AM
Subject: Re: $$Excel-Macros$$ Pls Help me in the attached file
To: excel-macros@googlegroups.com
why not
=SUMPRODUCT(
('Closing Price'!$B$2:$B$3473=$A16)*
('Closing Price'!$D$2:$D$3473=LEFT(B$15,2))*
('Closing Price'!$E$2:$E$3473=--RIGHT(B$15,4))*
('Closing Price'!$K$2:$K$3473))
On Thu, Mar 3, 2011 at 4:32 PM, Dharmesh Shah dharmeshsha...@gmail.com
wrote:
Dear All
I want some specific value using formula or any other method.
Please help me to get the required answer.
Thanks Regards
Dharmesh Shah
--
--
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$$ Re: Ashish Koul : Most helpful Member
thank you all On Thu, Mar 3, 2011 at 9:49 AM, Jenie janetdicks...@gmail.com wrote: Congratulation Ashish... keep it up -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of DILIPandey Sent: Wednesday, March 02, 2011 3:07 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member Congrats Ashish...!! Best Regards, DILIPandey On Mar 1, 8:38 pm, Ayush jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as *'Most Helpful Member'* for the month of Feb 2011. He has posted 97 posts (13% of total posts) in February 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and achieved this recognition consistently from last three months.This is really amazing. Ashish, You are not only helping on excel queries but inspiring many people to support voluntarily. *Many Many Thanks Ashish for wonderful support to group. * *About Ashish Koul* Ashish resides in Delhi, India and currently working with CSC. He is automation expert and his role is to automate tasks using VBA Macros and Advanced Excel. His favorite pass time is solving Excel Queries, Listening Music Traveling. Regards Ayush Jain Group Manager -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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
