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
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 anil.bha...@tatacommunications.com
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
Take the help of Pivot
On Sep 28, 10:40 am, shashank bhosle catchshashankbho...@yahoo.co.in
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 @
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
--
--
Use this formula to check same
=COUNTIF($B$2:$B$14,B2)
On May 28, 6:18 pm, Omar omar27...@gmail.com wrote:
PUT THIS FORMULA IN C2
=IF(COUNTA(B:B)COUNTA(A:A);NO;INDIRECT(B COUNTA(B:B)))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of kannan excel
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 yashr...@gmail.com wrote:
Hi Renuka,
You can use TRIM formula. Like
=TRIM(A1)
Thanks and Regards
Yogesh Gohil
On Tue, Apr 26, 2011 at 11:12
Count of Divisions PoorAvg GoodV Good
Total
Grand Total
Total Avg Avg Total
Total GoodGood Total Total
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 tricks and links :
http
Plz share your code
On Feb 21, 2:06 pm, rakesh kumar rakeshshail2...@gmail.com wrote:
Hi Dearests,
Please Help Code Doesn't Work
On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar
rakeshshail2...@gmail.comwrote:
*thanks Daniel Ji for the reply... here what I need and what the code
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
--
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
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
Kindly use text to column Function for above result
Regards
Vijay
On Jan 31, 11:52 pm, jmccaski jmccask...@gmail.com 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
With the help of pivot this can be possible
On Jan 31, 9:45 pm, Jitender kumar jk9779771...@gmail.com 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
Kindly attach the XL
On Jan 20, 10:53 am, Manoj kumar manoj.vishwakarma...@gmail.com
wrote:
please send us an attachment..
Regards,
Manoj Kumar
On Thu, Jan 20, 2011 at 9:51 AM, solsbee joesolsbe...@gmail.com wrote:
I am doing a data dump into and excel spreadsheet and the date
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
Dashboard 1 Looking better
On Jan 19, 1:13 pm, Kal xcel kalx...@gmail.com 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
not getting any idea after seeing ur data,
plz elaborate ur issue
On Jan 21, 4:21 am, Prakash Gusain gusainprak...@gmail.com 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
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
Following are the Details
The Company Name is RS Components Joint Venture With CS
CTC Negotiable
Excel Need Advanced no Macro require
Location Noida
www.rsindia.com
On Jan 3, 9:33 am, saggi realsa...@gmail.com wrote:
Dear member,
I have an requirement in MIS dept with Exp 2-4 yr
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 :
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 noorain.ans...@gmail.com wrote:
Dear VJ,
Please see attachment.
Thanks,
Noorain Ansari
-- Forwarded message
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/groups
.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 koul.ash...@gmail.com wrote:
chekc the attachment see if it helps
On Wed, Nov 10, 2010 at 8:03 AM, in.vaib...@gmail.com wrote:
Hi,
Write following formula beside date
You can change Manually... Do F2 then = existing value * 40%
Else through macro it can easily possible
On Nov 8, 10:36 am, Vaaibhav vaaibhavjhav...@gmail.com wrote:
Hello All
Is there any shortcut for changing values in various cells (same
column) to a same multiplier. I am just elaborationg
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 @
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 @
Use Pivot table on unique value, It could be on Code or Distributor
Name
On Aug 17, 10:51 am, Kal xcel kalx...@gmail.com 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
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 @
Please shera the Sample Data
On Jul 27, 9:42 pm, flebber flebber.c...@gmail.com 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
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. Join
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
=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 :
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 @
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 @
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
--
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 @
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 jaihumtu...@gmail.com wrote:
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
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
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 @
Hi! Parag,
What Exactly output u want its not clearI 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 paragdafal2...@gmail.com wrote:
Dear Sir,
Please help me in the formula for countif other. i
Seach over Google.U will lots examples
On Jun 29, 9:31 pm, Satti Charvak sat...@gmail.com wrote:
Hi All,
Can anybody please send me some examples of complex scenarios where the
sumproduct formula has been used...
Kind Regards,
Satti Charvak
--
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 @
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 mark@gmail.com wrote:
Hi
I have a set of data which I need
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.
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
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 ahmedhon...@gmail.com wrote:
Dear Team,
Please help out to frame a Formula for the attach, I need it using the
Worksheet Functions,
Just paste this formula that will work same
=IF(B50=material,10.3%,4.12%)
On May 25, 3:06 pm, Jai jaihumtu...@gmail.com 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
not getting u completely.plz elaborate or share ur number
On May 21, 8:17 pm, muralidhar e emuralidha...@gmail.com 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
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 :
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 sanjaysoni2...@yahoo.co.in wrote:
Dear All,
Please help me to provide a macro code for selecting a variable range.
Suppose for example
Plz go through below given web Page for better understanding
http://support.microsoft.com/kb/214142
On May 20, 3:14 pm, Venkatesan c venkat1@gmail.com wrote:
Dear Group,
Any send me with example Multiple conditions Lookup
--
Kindly try this formula...
=IF(AND(G3=G4,H4=H3,J3J4,L20),1,0)+1
On May 20, 4:14 am, subs subbu1...@gmail.com wrote:
ocity ostate carrier price
a b X 1200
a b Y 1290
c d X 1300
c d Z 1500
e
=IF(AND(G2=G3,H2=H3,K20),0,1) for First Row
=IF(AND(G3=G4,H3=H4,K30),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 X
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
59 matches
Mail list logo