$$Excel-Macros$$ Getting Array out of Bound Error

2013-09-01 Thread saggi
Dear All, Don't know what happened all of sudden, below given code giving Arrgy Out of bound error. Worked fine till yesterday. Below given code i am using for download attachment from outlook to my specific folder. debug n highlighted in yellow color where i am getting above mention error

Re: $$Excel-Macros$$ Other possibility

2011-11-27 Thread saggi
Buckets > 0 upto 50 M > 51,000,000 51- to 100M >101,000,000 101 to 300M >301,000,000 301 to 500M >501,000,000 501M to 1 Bn > 1,000,000,001 1 Bn + First Make table Then Apply below give Vlookup Formula Instead of Exact Reference(0

$$Excel-Macros$$ Re: Numbers errors

2011-09-28 Thread saggi
Kindly Share the sheet On Sep 28, 1:09 pm, Anil Bhange wrote: > Hi Experts, > > I wanted your help in below points, > > 1.    In excel my companies Bank account number is more than 20 digit > > 2.    And there are approx. 100 bank account numbers > > 3.    When I copy those numbers from one excel

$$Excel-Macros$$ Re: Format to be Changed!$$$$$$$$$

2011-09-28 Thread saggi
Take the help of Pivot On Sep 28, 10:40 am, shashank bhosle wrote: > Hello Friends, > > I have attach the sheet which included two table > T1 > T2 > > i want to change the T1 data to T2 > > Please help > > Regards > Shashank > 9422927499 > >  Phase I.xls > 44KViewDownload -- ---

Re: $$Excel-Macros$$ PDF File

2011-06-16 Thread saggi
Yeah this is very useful siten quick tooo -- -- 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.l

$$Excel-Macros$$ Sr. Exe MIS Needed

2011-06-09 Thread saggi
Key Skill : Advanced Knowledge of XL ( Lookup, Pivot, Count if , Sum if ) Prefer : Analytical bend of mind Location: Sec-60 Noida, Salary : 2-3 Lacs ( Depends on Work Exp) Mail me @ realsa...@gmail.com -- -- Some

Re: $$Excel-Macros$$ Need Matching excel formula

2011-05-30 Thread saggi
Use this formula to check same =COUNTIF($B$2:$B$14,B2) On May 28, 6:18 pm, "Omar" wrote: > PUT THIS FORMULA IN "C2" > > =IF(COUNTA(B:B) > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of kannan excel > Sent: Saturday, May 28, 2011 7:24 AM > To: excel-macr

Re: $$Excel-Macros$$ database concept - Reg

2011-05-18 Thread saggi
Create a custom list by typing in values Click the Microsoft Office Button , and then click Excel Options. Click the Popular category, and then under Top options for working with Excel, click Edit Custom Lists. In the Custom Lists box, click NEW LIST, and then type the entries in the List entries

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

2011-04-27 Thread saggi
Use Clean (a1) Formula Clean Formula remove special character from cell which r not visible. regards Vijay On Apr 26, 1:31 pm, Yogesh Gohil wrote: > Hi Renuka, > > You can use TRIM formula. Like > =TRIM(A1) > > Thanks and Regards > Yogesh Gohil > > > > > > > > On Tue, Apr 26, 2011 at 11:12 AM,

$$Excel-Macros$$ Re: Problem in pivot table

2011-04-15 Thread saggi
Count of Divisions PoorAvg GoodV Good Total Grand Total Total Avg Avg Total Total GoodGood Total Total Divisi

$$Excel-Macros$$ Re: Need formula to determine if combination is valid

2011-03-30 Thread saggi
Hi I don't know your valid criteria, But you can compare values from below given formula =IF(AND(B2=B3,A2=A3),"Valid","invalid") -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

$$Excel-Macros$$ Re: Fomula to find the Missing Numbers in the sequence - Reg

2011-02-28 Thread saggi
Insert new column then use this formula in column C =RIGHT(B3,3) =IF(C2-C1=1,"","missing") Regards Saggi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tric

Re: $$Excel-Macros$$ -- Please Help Code Doesn't Work

2011-02-21 Thread saggi
Plz share your code On Feb 21, 2:06 pm, rakesh kumar wrote: > Hi Dearests, > > Please Help Code Doesn't Work > > On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar > wrote: > > > > > > > > > > > *thanks Daniel Ji for the reply... here what I need and what the code > > doesn't do.* > > * > > * > > *Th

excel-macros@googlegroups.com

2011-02-20 Thread saggi
Just Go on DATA ribbon in Xl, Then Other Sources, then Give the path of SQL table this exercise need to done once. after onward same u can pull from Existing Connection just need to given Username & Password. Regards Vijay -- -

Re: $$Excel-Macros$$ Need Solution Nested If Formula

2011-02-16 Thread saggi
YES ASHISH, I WANT to chnage the formula for incorrect option.where i mention incorrect there formula picking wrong values -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and li

Re: $$Excel-Macros$$ Need Solution Nested If Formula

2011-02-16 Thread saggi
Thanks Ashish for your reply, but it no going to solve my purpose. Plz go through the excel and see wht kind of result i am looking for. Thanks in advance -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ Re: Problem Faced in excel

2011-01-31 Thread saggi
With the help of pivot this can be possible On Jan 31, 9:45 pm, Jitender kumar wrote: > Dear Experts , > > Thanks for your response . But look the sheet carefully. I have to use > code & Rname as heading from raw data.and rest data in next rows. > There should be blank row between second code & R

$$Excel-Macros$$ Re: How to extract data from an array

2011-01-31 Thread saggi
Kindly use text to column Function for above result Regards Vijay On Jan 31, 11:52 pm, jmccaski wrote: > I have an arry of over 21,000 rows with data in this format: > VarName TimeString      VarValue > Pos     27.01.2011 12:49:35     32 > Pres    27.01.2011 12:49:35     -2 > Setpt   27.01.2011

$$Excel-Macros$$ Re: Help req

2011-01-20 Thread saggi
not getting any idea after seeing ur data, plz elaborate ur issue On Jan 21, 4:21 am, Prakash Gusain wrote: > What are you looking for Rakesh?  Kindly explain it little bit more. > > Prakash Singh Gusainhttp://prakashgusain.blogspot.com > > On Jan 20, 6:01 pm, Rakesh Sharma wrote: > > > > > > >

$$Excel-Macros$$ Re: Sales Dashboard

2011-01-20 Thread saggi
Dashboard 1 Looking better On Jan 19, 1:13 pm, Kal xcel wrote: > Dear All, > > I am sharing two types of outlook of a Sales Dashboard which I am preparing > for my company. I need your honest comment that looks wise which one is > better. > > Thanks in advance > > Kalyan > >  Dashboard.xlsx > 50K

$$Excel-Macros$$ Re: Sumproduct Query ********** Ashish Koul

2011-01-20 Thread saggi
Kindly go through below given link, Surely u will get all answer of your query http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ Regards Vijay -- -- Some important links for excel users: 1. Follow us on TW

Re: $$Excel-Macros$$ Sumifs and date formatting

2011-01-20 Thread saggi
Kindly attach the XL On Jan 20, 10:53 am, Manoj kumar wrote: > please send us an attachment.. > > Regards, > Manoj Kumar > > > > > > > > On Thu, Jan 20, 2011 at 9:51 AM, solsbee wrote: > > I am doing a data dump into and excel spreadsheet and the date format > > that I get is MMDD.  I am try

Re: $$Excel-Macros$$ Formula of the week - share your best formula

2011-01-17 Thread saggi
Mine Fav Formula this week is =COUNTIF(A$3:A3,A3) It resolved my headache...Give ranking n order number for repetitive values Love tht one -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

$$Excel-Macros$$ Re: MIS Position Requirement

2011-01-03 Thread saggi
Following are the Details The Company Name is RS Components Joint Venture With C&S CTC Negotiable Excel Need Advanced no Macro require Location Noida www.rsindia.com On Jan 3, 9:33 am, saggi wrote: > Dear member, > > I have an requirement in MIS dept with Exp 2-4 yr... Kind

$$Excel-Macros$$ MIS Position Requirement

2011-01-02 Thread saggi
Dear member, I have an requirement in MIS dept with Exp 2-4 yr... Kindly Share your CVs. Regards Vijay -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.

Re: Fwd: $$Excel-Macros$$ Values Against Max Values

2010-12-22 Thread saggi
Dear Noorani, Thanks for help, kindly go through my question, Its easy to retrieve Max value but i need Value againt the max value. On Dec 22, 1:18 pm, NOORAIN ANSARI wrote: > Dear VJ, > > Please see attachment. > > Thanks, > Noorain Ansari > > > > -- Forwarded message -- > From:

$$Excel-Macros$$ Values against max values

2010-12-21 Thread saggi
nd 10 200 Regards Saggi 9871459832 -- -- 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/g

Re: $$Excel-Macros$$ Help: Using SUMIF(S) Function

2010-11-10 Thread saggi
.e. In cell C4: =text(B4,"mmm") After this use =SUMIF($C$3:$C$25,I8,$A$3:$A$25) On Nov 10, 1:45 pm, ashish koul wrote: > chekc the attachment see if it helps > > > > > > On Wed, Nov 10, 2010 at 8:03 AM, wrote: > > Hi, > > > Write following formula beside date column, i.e. In cell C4: > >

$$Excel-Macros$$ Re: How to change multiple values

2010-11-08 Thread saggi
You can change Manually... Do F2 then = existing value * 40% Else through macro it can easily possible On Nov 8, 10:36 am, Vaaibhav wrote: > Hello All > > Is there any shortcut for changing values in various cells (same > column) to a same multiplier. I am just elaborationg - say in Column A > i

$$Excel-Macros$$ Re: lookup function comparing 3 columns

2010-09-23 Thread saggi
Kindly share the file for better understanding -- -- 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.

$$Excel-Macros$$ Re: Change Colour of a Cell if it contains certain value

2010-08-26 Thread saggi
Yeah , you can do same with Conditional Formatting -- -- 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:/

$$Excel-Macros$$ Re: Top ten distributor

2010-08-18 Thread saggi
Use Pivot table on unique value, It could be on Code or Distributor Name On Aug 17, 10:51 am, Kal xcel wrote: > Dear experts, > > I have SAP sales data, how to get top 10 distributor frm that huge data. One > distributor billed many times. Is there any mechanism?? > > Thanks in advance > > Kalya

$$Excel-Macros$$ Re: Bring in all matched unique values using lookup

2010-08-09 Thread saggi
Pivot can work for you... -- -- 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?g

$$Excel-Macros$$ Re: Remove selected cell contents

2010-07-27 Thread saggi
Please shera the Sample Data On Jul 27, 9:42 pm, flebber wrote: > I have a column containing cells which house several delimited values > and a dollar value. I want to be able to remove the delimited values > and leave the dollar value in the cell in currency format. > > the cells contain informa

$$Excel-Macros$$ Re: Auto Calculate Number to Percent

2010-07-22 Thread saggi
I Don't think its possible by Self Calculating atleast u have to put some criteria here just add another column "D" for %age calculation -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

$$Excel-Macros$$ Re: how do you identify the first space within a series of words within a a text

2010-07-22 Thread saggi
Use = Search (" ",cellreference) Like Search (" ", White Black) result will be 6 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Jo

Re: $$Excel-Macros$$ Need SUMIF with 3 criteria

2010-07-19 Thread saggi
=SUM(IF(($A$1:$A$15=A2)*($D$2:$D$50=D8)*($C$3:$C$30=C5),1,0)) This way you can use Sum IF formula for 3 Condition -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http:

$$Excel-Macros$$ Re: Personal Macro giving serious problem to excel

2010-07-19 Thread saggi
This Problem Generally come with OS Xp -- -- 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

$$Excel-Macros$$ Re: Create a Unique Name List

2010-07-19 Thread saggi
Consolidate data in one place n Run Pivot -- -- 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.linke

Re: $$Excel-Macros$$ Dashboard sheet

2010-07-11 Thread saggi
I fully agree with Rajesh... Dashboard n Scorecard vary Business to Business( Industry).. Its nothing but Showing Reports in Numbers with Some Graphical persentation. For some readymande templates you can search on google -- --

$$Excel-Macros$$ Re: Please check the attachment.

2010-07-10 Thread saggi
I am not sure i m understanding you correct n fully.on given XL issue possible solution is Suppose Name in Column A Values in cloumn B & C... Filter on complete Column then select black cells..after tht = c2 or C3 Paste it till bottom On Jul 10, 1:03 pm, Jai wrote: > -- > Thanks For Mail.

$$Excel-Macros$$ Re: Query - Date Formula

2010-07-10 Thread saggi
Dear Nikhil, Use Data Validation for reflect the error -- -- 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 @

Re: $$Excel-Macros$$ Interview questions

2010-07-09 Thread saggi
In 4.5 yr experience i don't think anyone going to judge ur excel skill by vlookup n pivot... they will check ur technique abt Data Manipulation n all...n how gud your in Report Automation. -- -- Some important links

$$Excel-Macros$$ Re: Extracting Embedded Word documents from Excel

2010-07-08 Thread saggi
Kindly share the Document -- -- 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?g

Re: $$Excel-Macros$$ Interview questions

2010-07-08 Thread saggi
I m not sure how many year experience you have in MIS If its executive level interview then prepare Vlookup with ISNA, Conditional Formatting, Sumif n Counif formulas and Pivot Table -- -- Some important links fo

$$Excel-Macros$$ Re: Pls send examples of complex scenarios using sumproduct formula

2010-06-30 Thread saggi
Seach over Google.U will lots examples On Jun 29, 9:31 pm, Satti Charvak wrote: > Hi All, > >  Can anybody please send me some examples of complex scenarios where the > "sumproduct" formula has been used... > > Kind Regards, > Satti Charvak -- ---

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

2010-06-30 Thread saggi
Hi! Parag, What Exactly output u want its not clear"I want that I can count the no.of dispathces I done in 3july for old date.". Saggi realsa...@gmail.com On Jun 30, 4:27 pm, parag dafal wrote: > Dear Sir, >             Please help me in the formula for countif & other. i

$$Excel-Macros$$ Re: SumIF Sumproduct

2010-06-29 Thread saggi
Kindly Share the Sample Sheet or data -- -- 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

$$Excel-Macros$$ Re: Urgent Help needed regarding using macro

2010-06-25 Thread saggi
Use This formula just change the range =SUMPRODUCT(MAX(($A$2:$A$100=A3)*($D$2:$D$100))) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excelda

$$Excel-Macros$$ Re: Using sum function for Unknown range

2010-06-23 Thread saggi
If you are not using Dynamic Range then use simple Sum formula, Just change range n column number Sub SUM() ActiveSheet.Select ActiveCell.FormulaR1C1 = "=sum(R[-1]C:R[-22]C)" Range("B23").Select End Sub On Jun 24, 7:58 am, Markkim wrote: > Hi > > I have a set of data which I need to sum up bet

$$Excel-Macros$$ Hi!!!!!!!!! to all Member

2010-05-29 Thread saggi
Kindly let me know how to attach file here, Many of guys are facing same issue -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

$$Excel-Macros$$ Re: New to the group - basic question

2010-05-29 Thread saggi
what is this 65% of some value yaa 35% of the value hmmm need details of this If 18.25 is portion 35% of the then it will give u 100% of the value by this formula -- -- Some important links for excel users: 1. Fol

$$Excel-Macros$$ Re: Need Formula Help

2010-05-27 Thread saggi
1) I have slightly confutationon increment column u need max value or latest value 2) how to upload Xl file here On May 26, 6:53 pm, Ahmedhonest wrote: > Dear Team, > > Please help out to frame a Formula for the attach, I need it using the > Worksheet Functions, > > Any help or valua

Re: $$Excel-Macros$$ Need Help

2010-05-26 Thread saggi
Use those code : Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = "Combined" ' copy headings Sheets(2).Activate Range("A1").EntireRow.Select Selection.Copy Destination:=Sheets(1).

Re: $$Excel-Macros$$ Help Regarding

2010-05-25 Thread saggi
Just paste this formula that will work same =IF(B50="material",10.3%,4.12%) On May 25, 3:06 pm, Jai wrote: > Dear All > > 1.    When we Selcet  the Type of Work  ( Material ) Service tax  Show 4.12 > %, > > 2.   When we Selcet  the Type of Work    ( Labour  ) Service tax  Show 10.3 > % > > Can

$$Excel-Macros$$ All Dear Member

2010-05-21 Thread saggi
Dear Member, Kindly Share your Cell Number also with ur Issue for immediate resolution. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyti

Re: $$Excel-Macros$$ total for unique values

2010-05-21 Thread saggi
not getting u completely.plz elaborate or share ur number On May 21, 8:17 pm, muralidhar e wrote: > hai friends, > > This is murali when iam entering the Batches or numbers(values) in a column > it should be repeat more than one time, i want the sum for entering the > values. plz help and gi

Re: $$Excel-Macros$$ Help Reqired Multiple conditions Lookup

2010-05-21 Thread saggi
Plz go through below given web Page for better understanding http://support.microsoft.com/kb/214142 On May 20, 3:14 pm, Venkatesan c wrote: > Dear Group, > > Any send me with example Multiple conditions Lookup > > -- > ---­

Re: $$Excel-Macros$$ Macro :- Selecting a variable range in a excel sheet

2010-05-21 Thread saggi
Use this Code Sub range() R = Application.WorksheetFunction.CountA(RANGE("A1:A65536")) RANGE("A1:B" & R).Select End Sub On May 19, 2:40 pm, SANJAY SONI wrote: > Dear All, > > Please help me to provide a macro code for selecting a variable range. > > Suppose for example the data enter fro

Re: $$Excel-Macros$$ rank column

2010-05-20 Thread saggi
=IF(AND(G2=G3,H2=H3,K2>0),0,1) for First Row =IF(AND(G3=G4,H3=H4,K3>0),K3+1,1) For first row onward ocity  ostate  carrier price Rank a  b X 12001 a  b Y 290 2 a  b Y 11003 a  b Y 15004 c  d

Re: $$Excel-Macros$$ rank column

2010-05-20 Thread saggi
Kindly try this formula... =IF(AND(G3=G4,H4=H3,J3>J4,L2>0),1,0)+1 On May 20, 4:14 am, subs wrote: > ocity  ostate  carrier  price > a          b         X        1200 > a          b         Y       1290 > c          d         X        1300 > c          d         Z         1500 > e          f  

Re: $$Excel-Macros$$ Help needed to calculate Increment

2010-05-17 Thread saggi
It can be more simpler by using Vlookup function effectively. Use 1 instead of 0, dont go for exact match Example : =VLOOKUP($B3, 'Lookup - Source'!$B$3:$H$30,7, 0) Explaination $B3 --> Cell address containing Lookup value 'Look