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
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
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
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
--
---
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
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
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
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
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,
Count of Divisions PoorAvg GoodV Good
Total
Grand Total
Total Avg Avg Total
Total GoodGood Total Total
Divisi
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
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
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
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
--
-
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
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
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
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
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:
>
>
>
>
>
>
>
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
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
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
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
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
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.
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:
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
.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:
>
>
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
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.
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:/
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
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
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
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
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
=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:
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
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
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
--
--
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.
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 @
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
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
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
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
--
---
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
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
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
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
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
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
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
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).
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
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
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
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
>
> --
> ---
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
=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
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
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
62 matches
Mail list logo