date:20110216

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

2011-02-16 Thread ashish koul

try this

On Thu, Feb 17, 2011 at 9:43 AM, saggi  wrote:

> 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 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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


NEED_sOL.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Match and index formula help required

2011-02-16 Thread Jagadeesh B S

Ashish Koul
Thank you soo much for the help...




On Wed, Feb 16, 2011 at 8:31 PM, ashish koul  wrote:

> check the attachment
>
> On Wed, Feb 16, 2011 at 6:19 PM, Jagadeesh B S  wrote:
>
>> Hello all
>>
>>
>>
>> I have date like
>>
>> Cash in Banks - Oper. Accts.
>>
>> 10
>>
>> -
>>
>> 100099
>>
>> Cash in Banks - Time Deposits
>>
>> 101000
>>
>> -
>>
>> 101099
>>
>> Restrictive Cash - Current
>>
>> 102000
>>
>> -
>>
>> 102099
>>
>> Marketable Securities - Trading
>>
>> 103000
>>
>> -
>>
>> 103099
>>
>> Marketable Securities - Available for Sale
>>
>> 104000
>>
>> -
>>
>> 104099
>>
>> Marketable Securities - Held to Maturity
>>
>> 105000
>>
>> -
>>
>> 105099
>>
>> Marketable Securities - Partnerships
>>
>> 105500
>>
>> -
>>
>> 105599
>>
>>
>>
>>
>>
>> In cell A1 I have data like 101009
>>
>> A2 105060**
>>
>> I need a formula to  which should give data for me is like this :
>>
>> A B
>>
>> 101009  Cash in Banks - Time Deposits
>>
>> 105060  Marketable Securities - Held to Maturity
>>
>>
>>
>>
>>
>> I guess this can be done through match and index but I am not able to get
>> it..
>>
>> Please help me with this regard.
>>
>> Thanks
>>
>> Jagadeesh
>>
>> --
>>
>> --
>> 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 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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
>

-- 
--
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$$ 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 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$$ data in horizontal row

2011-02-16 Thread ashish koul

try this

Sub test()
Dim i, j As Long
Dim s As String
j = 1
For i = 3 To Sheets(1).Range("a2").End(xlDown).Row
s = ""
k = i
Sheets(1).Range("h" & j).Value = Sheets(1).Range("a" & i).Value
Do Until Sheets(1).Range("a" & i).Value <> Sheets(1).Range("a" & i +
1).Value
s = s & "-" & Sheets(1).Range("c" & i).Value
i = i + 1
Loop
Sheets(1).Range("i" & j).Value = Sheets(1).Range("b" & k).Value & s & "-" &
Sheets(1).Range("c" & i).Value
j = j + 1
Next
End Sub




On Tue, Feb 15, 2011 at 9:16 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

> hi please use this simple procedure
>
>
> Excel Text to Column Command
> The Text to Column command allows you to break text in one column into
> several columns. For example, if you have LastName, FirstName in a column,
> you can break the text into two columns—one containing LastName and the
> other containing FirstName.
>
> 1. Insert as many columns to the left of the column to be split as needed.
> 2. Select the cells to be separated.
> 3. Pull down the Data menu and choose Text to Columns
> 4. Choose Delimited and click on Next
> 5. Choose the Delimiter that is used in the column, such as comma and click
> on Next
> 6. To set the column data format, click on the column and then click on the
> format desired under column data format (this is optional).  Repeat this for
> each column and click on Finish.
>
> Excel Transpose Command
> Use the transpose feature to switch data from vertical to horizontal.
>
> 1. Select the cells to switch
> 2. Click on the Copy tool
> 3. Click where you want the data to be transposed to
> 4. Pull down the Edit menu and choose Paste Special
> 5. Click on Transpose and click on OK
>
>
> Thanks,
> Raj
>
>
> On Tue, Feb 15, 2011 at 1:37 AM, Hems  wrote:
>
>> Hi Guys,
>>
>> Pls check attached excel sheet.
>>
>> I have data in across 2 columns which i want move in one row through
>> macro, is it possible?
>>
>> actually the data is extracted from access database so if its poss through
>> macro then i can process in access rather trolling it through excel.
>>
>> appreciate your efforts and thanks in advance.
>>
>> --
>> Kind Regards,
>> Hems
>>
>> --
>>
>> --
>> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$ columns into rows, with a twist

2011-02-16 Thread ashish koul

can you please send  the sample workbook



On Thu, Feb 17, 2011 at 3:03 AM, RFisher  wrote:

> Hi everyone,
>  It's great to find a list with such a helpful group. I have a
> question. I received some recent weather data (precipitation in mm)
> for weather stations in Canada; however, the file isn't quite
> formatted for how I need it in order to analyse it. The excel file is
> formatting like the following (Station ID is the identification number
> for the station, year is the year the measurements were made, month is
> the month (1-12), decimals is a constant column, and the Day1-Day31
> are maximum precipitation on each day of the month (see following data
> outline):
> StationID YearMonth Decimals Day1   Day 2   Day3
> Day4Day 31
> 23056  2003  13 0
> 12.2 13   7   10
> 23056  2003  23 1
> 5   12 0.6  20
>
> There are unfortunately several thousand rows and I need the table to
> look like the following:
> StationID Year   Month  Decimals DayPrecip
> 23056  20031 3   10
> 23056  20031 3   2   12.2
> 23056  20031 3   313
> 23056  20031 3   4 7
> ...
> 23056  2003 13   31   10
> 23056  2003 231 1
> etc
>
> Note that there are several different stations, over 7 years and for
> all months (January to December).
>
> Thanks for any help. I hope that's enough information that you might
> be able to provide a way to this automatically with a macro or some
> other excel functions.
> Thanks!
> Ryan
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$ Dynamic range

2011-02-16 Thread Skanda

Thanks Ashish.

On Wed, Feb 16, 2011 at 1:12 AM, ashish koul  wrote:

> see if this helps
>
>
> Sub growth()
> Dim i As Long
> i = Range("s21").End(xlDown).Row
> Columns("S:S").Select
> Selection.Insert Shift:=xlToRight
> Range("S21").Select
> ActiveCell.FormulaR1C1 = "Growth"
> Range("S23").Select
> ActiveCell.FormulaR1C1 = "=(RC[-2]-RC[-1])/RC[-2]"
> Range("S23").Select
> Selection.NumberFormat = "0.00%"
> Selection.AutoFill Destination:=Range("S23:S490")
> Range("S23:S" & i).Select
> End Sub
>
>
>
>   On Wed, Feb 16, 2011 at 2:57 AM, Skanda wrote:
>
>> Sub growth()
>> '
>> ' growth Macro
>> '
>> Columns("S:S").Select
>> Selection.Insert Shift:=xlToRight
>> Range("S21").Select
>> ActiveCell.FormulaR1C1 = "Growth"
>> Range("S23").Select
>> ActiveCell.FormulaR1C1 = "=(RC[-2]-RC[-1])/RC[-2]"
>> Range("S23").Select
>> Selection.NumberFormat = "0.00%"
>> Selection.AutoFill Destination:=Range("S23:S490")
>> Range("S23:S490").Select
>> End Sub
>>
>>
>>
>> In the above code, the range is set from S23 to S490.But there could be
>> changes in the number of records in the future.
>> how to make it more dynamic, keeping the S23 as constant but S490 to
>> change depending on the records from RC[-2] and RC[-1].
>> i.e if columns RC[-2] and RC[-1] have 5000 records in future how make the
>> above code dynamic?
>>
>> --
>>
>> --
>> 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 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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
>

-- 
--
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

$$Excel-Macros$$ How to Get Filtered Data from SQL server into Microsoft Excel 2007

2011-02-16 Thread Manish

I want to import data from SQL server 2005 into Excel 2007 using
Data=>from other sources=>From SQL server. I am able to import
complete table (e.g. Item) but there are too many unnecessary fields
as well as records which also get imported. I want to filter the data
before importing into excel but don't know how to do that? For e.g. I
want to import "item" table with only the records whose item code
starts with FG and only "code" and "unit price" fields.

Can anybody help me out in this regard?

Manish

-- 
--
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

$$Excel-Macros$$ columns into rows, with a twist

2011-02-16 Thread RFisher

Hi everyone,
 It's great to find a list with such a helpful group. I have a
question. I received some recent weather data (precipitation in mm)
for weather stations in Canada; however, the file isn't quite
formatted for how I need it in order to analyse it. The excel file is
formatting like the following (Station ID is the identification number
for the station, year is the year the measurements were made, month is
the month (1-12), decimals is a constant column, and the Day1-Day31
are maximum precipitation on each day of the month (see following data
outline):
StationID YearMonth Decimals Day1   Day 2   Day3
Day4Day 31
23056  2003  13 0
12.2 13   7   10
23056  2003  23 1
5   12 0.6  20

There are unfortunately several thousand rows and I need the table to
look like the following:
StationID Year   Month  Decimals DayPrecip
23056  20031 3   10
23056  20031 3   2   12.2
23056  20031 3   313
23056  20031 3   4 7
...
23056  2003 13   31   10
23056  2003 231 1
etc

Note that there are several different stations, over 7 years and for
all months (January to December).

Thanks for any help. I hope that's enough information that you might
be able to provide a way to this automatically with a macro or some
other excel functions.
Thanks!
Ryan

-- 
--
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$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

2011-02-16 Thread ashish koul

welcome.

On Wed, Feb 16, 2011 at 8:59 PM, Rajesh K R wrote:

> Hi Ashish
> Thank You very much.I checked  the code it is working well.
>
> Regards & Thanks
> Rajesh Kainikkara
>
>
> On 2/16/11, ashish koul  wrote:
> > Sub tests()
> > Dim i As Long
> >
> > For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
> > If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
> > Sheets(2).Range("b" & i).Value) = 0 Then
> > Sheets(2).Select
> > Sheets(2).Range("b" & i).Select
> > Selection.EntireRow.Copy
> > Sheets(1).Select
> >
> > Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 1).Select
> > ActiveSheet.Paste
> > End If
> >
> > Next i
> >
> >
> >
> >
> > End Sub
> >
> >
> > On Wed, Feb 16, 2011 at 8:40 PM, Rajesh K R
> > wrote:
> >
> >> Hi
> >> Thanks for ur fast reply, now it copying the data in column"B" if I
> >> want to copy the entire raw how to change the code.
> >>
> >> Regards & Thanks
> >> Rajesh kainikkara
> >>
> >> On 2/16/11, ashish koul  wrote:
> >> > Sub tests()
> >> > Dim i As Long
> >> >
> >> > For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
> >> > If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
> >> > Sheets(2).Range("b" & i).Value) = 0 Then
> >> > Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 2).Value =
> >> > Sheets(2).Range("b" & i).Value
> >> > End If
> >> >
> >> > Next i
> >> >
> >> >
> >> >
> >> >
> >> > End Sub
> >> >
> >> >
> >> > On Wed, Feb 16, 2011 at 7:49 PM, Rajesh K R
> >> > wrote:
> >> >
> >> >> Hi Experts
> >> >> How can select data from sheet2 which don't exist in sheet1 and copy
> >> >> the entire raw and paste in sheet1. Pls find the attached file to get
> >> >> more details
> >> >>
> >> >> Regards
> >> >> Rajesh Kainikkara
> >> >>
> >> >> --
> >> >>
> >> >>
> >>
> --
> >> >> 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 
> >> > *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
> >> >
> >>
> >> --
> >>
> >>
> --
> >> 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 
> > *akoul*.wordpress.com 
> > My Linkedin Profile 
> >
> >
> > 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

Re: $$Excel-Macros$$ Query

2011-02-16 Thread ashish koul

IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),"Doubtful",IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Loss"),"Loss",IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Substandard"),"Substandard","Regular")))

type this in e4
On Wed, Feb 16, 2011 at 9:59 PM, Aamir Shahzad wrote:

> Maximum 4 classifications
> 1) Regular
> 2) Substandard
> 3) Doubtful
> 4) Loss
>
> On Tue, Feb 15, 2011 at 8:34 PM, ashish koul wrote:
>
>> will it be these three classifications only
>>
>>
>> On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad 
>> wrote:
>>
>>> Thanks *Ashish *for reply but can you please provide formula without
>>> pivot. Condition you have understand that if sum of any classification is
>>> grater then others,it shows that value.
>>>
>>>
>>>
>>> On Tue, Feb 15, 2011 at 8:14 AM, ashish koul wrote:
>>>


 On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad <
 aamirshahza...@gmail.com> wrote:

>
> Hi all experts,
>
> Please resolve my query by formula. sheet attached.
>
> Regards,
>
> Aamir Shahzad
> --
>
> --
> 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 
 *akoul*.wordpress.com 
 My Linkedin Profile 


 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

>>>
>>> --
>>>
>>> --
>>> 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 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> 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
>>
>
> --

$$Excel-Macros$$ Excel Templates on Call forecasting

2011-02-16 Thread cpmanoj

Hello All,

I am new to this forum..

Can any one of the experts provide me with the call center call volume
forecasting template for a long term basis and also a short term
basis.  It would be helpful if any one let me know the procedure or if
any other important tips to be considered for forecasting template.

Eagerly waiting for a line in reply.

Regards,
Manoj

-- 
--
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$$ Query

2011-02-16 Thread Aamir Shahzad

Maximum 4 classifications
1) Regular
2) Substandard
3) Doubtful
4) Loss

On Tue, Feb 15, 2011 at 8:34 PM, ashish koul  wrote:

> will it be these three classifications only
>
>
> On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad 
> wrote:
>
>> Thanks *Ashish *for reply but can you please provide formula without
>> pivot. Condition you have understand that if sum of any classification is
>> grater then others,it shows that value.
>>
>>
>>
>> On Tue, Feb 15, 2011 at 8:14 AM, ashish koul wrote:
>>
>>>
>>>
>>> On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad <
>>> aamirshahza...@gmail.com> wrote:
>>>

 Hi all experts,

 Please resolve my query by formula. sheet attached.

 Regards,

 Aamir Shahzad
 --

 --
 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 
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> 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
>>>
>>
>> --
>>
>> --
>> 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 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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
>

-- 
--
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$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

2011-02-16 Thread Rajesh K R

Hi Ashish
Thank You very much.I checked  the code it is working well.

Regards & Thanks
Rajesh Kainikkara


On 2/16/11, ashish koul  wrote:
> Sub tests()
> Dim i As Long
>
> For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
> If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
> Sheets(2).Range("b" & i).Value) = 0 Then
> Sheets(2).Select
> Sheets(2).Range("b" & i).Select
> Selection.EntireRow.Copy
> Sheets(1).Select
>
> Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 1).Select
> ActiveSheet.Paste
> End If
>
> Next i
>
>
>
>
> End Sub
>
>
> On Wed, Feb 16, 2011 at 8:40 PM, Rajesh K R
> wrote:
>
>> Hi
>> Thanks for ur fast reply, now it copying the data in column"B" if I
>> want to copy the entire raw how to change the code.
>>
>> Regards & Thanks
>> Rajesh kainikkara
>>
>> On 2/16/11, ashish koul  wrote:
>> > Sub tests()
>> > Dim i As Long
>> >
>> > For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
>> > If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
>> > Sheets(2).Range("b" & i).Value) = 0 Then
>> > Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 2).Value =
>> > Sheets(2).Range("b" & i).Value
>> > End If
>> >
>> > Next i
>> >
>> >
>> >
>> >
>> > End Sub
>> >
>> >
>> > On Wed, Feb 16, 2011 at 7:49 PM, Rajesh K R
>> > wrote:
>> >
>> >> Hi Experts
>> >> How can select data from sheet2 which don't exist in sheet1 and copy
>> >> the entire raw and paste in sheet1. Pls find the attached file to get
>> >> more details
>> >>
>> >> Regards
>> >> Rajesh Kainikkara
>> >>
>> >> --
>> >>
>> >>
>> --
>> >> 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 
>> > *akoul*.wordpress.com 
>> > My Linkedin Profile 
>> >
>> >
>> > 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
>> >
>>
>> --
>>
>> --
>> 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 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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 foll

Re: $$Excel-Macros$$

2011-02-16 Thread ashish koul

https://groups.google.com/group/excel-macros/subscribe?hl=en

click on unsubscribe




On Wed, Feb 16, 2011 at 7:31 PM, NOURREDINE BELHAJ <
nourredine.bel...@gmail.com> wrote:

> Hi All,
>
> I would like to be taken out from this distro list.
>
> Could you please help with this ?
> Thanks
> --
> Regards
>
> Nourredine BELHAJ
>
> +41783081988
> +33665248617
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$ Load image from the url

2011-02-16 Thread ashish koul

check this link

http://vbnet.mvps.org/index.html?code/internet/urldownloadtofilenocache.htm

see if it helps

On Tue, Feb 15, 2011 at 10:27 PM, San Pat  wrote:

> I am using a web url.
>
> Is there anyway I can covert/save web url in picture format and then call
> it in the below function?
>
> Regards,
> San
>
>
> On Tue, Feb 15, 2011 at 5:46 AM, ashish koul wrote:
>
>> Sub test()
>>
>> UserForm1.Image1.Picture = LoadPicture("D:\koul\krishna.jpg")
>> UserForm1.Show
>>
>>
>> End Sub
>>
>>
>>   On Tue, Feb 15, 2011 at 11:55 AM, San Pat wrote:
>>
>>> How I can load a image from a url using the LoadPicture function in
>>> userform.
>>>
>>> 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
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> 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
>>
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$ Nos. of Sundays between two days

2011-02-16 Thread ashish koul

j1 start date
j2 end date

monday =I
F(TEXT(J1,"")<>"Monday",NETWORKDAYS(J1,J2)/5,INT(NETWORKDAYS(J1,J2)/5)+1)

saturday =  INT(((J2-J1)-NETWORKDAYS(J1,J2))/2)

On Wed, Feb 16, 2011 at 7:10 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

> hi ashish,
>
> Can you please help to find out how many mondays and saturdays are
> present for the same above query.
> 01/16/2011 to 02/16/20111
>
>
> Thanks,
> Raj
>
>
>
> On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan wrote:
>
>>  Thank you very much for the prompt reply Sir.
>>
>>
>>
>> - Original Message -
>>
>> *From:* ashish koul 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Monday, February 14, 2011 8:17 PM
>> *Subject:* Re: $$Excel-Macros$$ Nos. of Sundays between two days
>>
>> start date in a1
>>
>> and end date in a2
>>
>> no of sundays  =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1
>>
>> On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan wrote:
>>
>>>  Dear Sir,
>>>
>>> Formula required for nos. of sundays between two days.
>>> e.g. if an employee has joined on 18/7/2010, how many sundays between
>>> 18/7/2010 and 31/01/2011.
>>>
>>> Thanks & 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
>>>
>>
>>
>>
>> --
>> *Regards*
>> **
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> 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
>>
>>   --
>>
>> --
>> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

2011-02-16 Thread ashish koul

Sub tests()
Dim i As Long

For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
Sheets(2).Range("b" & i).Value) = 0 Then
Sheets(2).Select
Sheets(2).Range("b" & i).Select
Selection.EntireRow.Copy
Sheets(1).Select

Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 1).Select
ActiveSheet.Paste
End If

Next i




End Sub


On Wed, Feb 16, 2011 at 8:40 PM, Rajesh K R wrote:

> Hi
> Thanks for ur fast reply, now it copying the data in column"B" if I
> want to copy the entire raw how to change the code.
>
> Regards & Thanks
> Rajesh kainikkara
>
> On 2/16/11, ashish koul  wrote:
> > Sub tests()
> > Dim i As Long
> >
> > For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
> > If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
> > Sheets(2).Range("b" & i).Value) = 0 Then
> > Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 2).Value =
> > Sheets(2).Range("b" & i).Value
> > End If
> >
> > Next i
> >
> >
> >
> >
> > End Sub
> >
> >
> > On Wed, Feb 16, 2011 at 7:49 PM, Rajesh K R
> > wrote:
> >
> >> Hi Experts
> >> How can select data from sheet2 which don't exist in sheet1 and copy
> >> the entire raw and paste in sheet1. Pls find the attached file to get
> >> more details
> >>
> >> Regards
> >> Rajesh Kainikkara
> >>
> >> --
> >>
> >>
> --
> >> 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 
> > *akoul*.wordpress.com 
> > My Linkedin Profile 
> >
> >
> > 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
> >
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

2011-02-16 Thread Rajesh K R

Hi
Thanks for ur fast reply, now it copying the data in column"B" if I
want to copy the entire raw how to change the code.

Regards & Thanks
Rajesh kainikkara

On 2/16/11, ashish koul  wrote:
> Sub tests()
> Dim i As Long
>
> For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
> If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
> Sheets(2).Range("b" & i).Value) = 0 Then
> Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 2).Value =
> Sheets(2).Range("b" & i).Value
> End If
>
> Next i
>
>
>
>
> End Sub
>
>
> On Wed, Feb 16, 2011 at 7:49 PM, Rajesh K R
> wrote:
>
>> Hi Experts
>> How can select data from sheet2 which don't exist in sheet1 and copy
>> the entire raw and paste in sheet1. Pls find the attached file to get
>> more details
>>
>> Regards
>> Rajesh Kainikkara
>>
>> --
>>
>> --
>> 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 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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
>

-- 
--
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$$ Need Solution Nested If Formula

2011-02-16 Thread ashish koul

hi you wanted to change the formula for incorrect option or you wanted to
mark the status correct or incorrect

On Wed, Feb 16, 2011 at 5:50 PM, saggi  wrote:

>
> 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 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$ Match and index formula help required

2011-02-16 Thread ashish koul

check the attachment

On Wed, Feb 16, 2011 at 6:19 PM, Jagadeesh B S  wrote:

> Hello all
>
>
>
> I have date like
>
> Cash in Banks - Oper. Accts.
>
> 10
>
> -
>
> 100099
>
> Cash in Banks - Time Deposits
>
> 101000
>
> -
>
> 101099
>
> Restrictive Cash - Current
>
> 102000
>
> -
>
> 102099
>
> Marketable Securities - Trading
>
> 103000
>
> -
>
> 103099
>
> Marketable Securities - Available for Sale
>
> 104000
>
> -
>
> 104099
>
> Marketable Securities - Held to Maturity
>
> 105000
>
> -
>
> 105099
>
> Marketable Securities - Partnerships
>
> 105500
>
> -
>
> 105599
>
>
>
>
>
> In cell A1 I have data like 101009
>
> A2 105060**
>
> I need a formula to  which should give data for me is like this :
>
> A B
>
> 101009  Cash in Banks - Time Deposits
>
> 105060  Marketable Securities - Held to Maturity
>
>
>
>
>
> I guess this can be done through match and index but I am not able to get
> it..
>
> Please help me with this regard.
>
> Thanks
>
> Jagadeesh
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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


sample new.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

2011-02-16 Thread ashish koul

Sub tests()
Dim i As Long

For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
Sheets(2).Range("b" & i).Value) = 0 Then
Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 2).Value =
Sheets(2).Range("b" & i).Value
End If

Next i




End Sub


On Wed, Feb 16, 2011 at 7:49 PM, Rajesh K R wrote:

> Hi Experts
> How can select data from sheet2 which don't exist in sheet1 and copy
> the entire raw and paste in sheet1. Pls find the attached file to get
> more details
>
> Regards
> Rajesh Kainikkara
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

$$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

2011-02-16 Thread Rajesh K R

Hi Experts
How can select data from sheet2 which don't exist in sheet1 and copy
the entire raw and paste in sheet1. Pls find the attached file to get
more details

Regards
Rajesh Kainikkara

-- 
--
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


SORT.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$

2011-02-16 Thread NOURREDINE BELHAJ

Hi All,

I would like to be taken out from this distro list.

Could you please help with this ?
Thanks
-- 
Regards

Nourredine BELHAJ

+41783081988
+33665248617

-- 
--
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$$ Nos. of Sundays between two days

2011-02-16 Thread Rajasekhar Praharaju

hi ashish,

Can you please help to find out how many mondays and saturdays are
present for the same above query.
01/16/2011 to 02/16/20111


Thanks,
Raj



On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan wrote:

>  Thank you very much for the prompt reply Sir.
>
>
>
> - Original Message -
>
> *From:* ashish koul 
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, February 14, 2011 8:17 PM
> *Subject:* Re: $$Excel-Macros$$ Nos. of Sundays between two days
>
> start date in a1
>
> and end date in a2
>
> no of sundays  =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1
>
> On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan wrote:
>
>>  Dear Sir,
>>
>> Formula required for nos. of sundays between two days.
>> e.g. if an employee has joined on 18/7/2010, how many sundays between
>> 18/7/2010 and 31/01/2011.
>>
>> Thanks & 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
>>
>
>
>
> --
> *Regards*
> **
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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
>
>   --
>
> --
> 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$$ Sales Dash Boards

2011-02-16 Thread ashish koul

http://chandoo.org/wp/excel-dashboards/


On Wed, Feb 16, 2011 at 5:57 PM, johnson john  wrote:

> Dear Members,
>
> Can  any one Pls. share few Excel Sales Dash Boards? It would be of great
> help to me in my day in and day out professional life.
>
>  Best Regards.,
> Johnson CA
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

$$Excel-Macros$$ Re: error checking VBA Excel 2003

2011-02-16 Thread BJthebear

Thanks Stuart - now working perfectly - until the next problem

Thanks once again

BJ

On Feb 16, 7:16 am, Stuart Redmann  wrote:
> > On Feb 15, BJthebear wrote:
> > > I have written a sub routine to add a name to a dynamic list but I
> > > have three problems with it and would be grateful for some advice.
>
> > > Sub InputNewUser()
>
> > > Dim Newuser As String
> > > Dim nextRow As Long
>
> [snipped some code]
>
>
>
> > > 'Ask for name of new user
>
> > > Newuser = Application.InputBox("Please enter name of new user (Surname
> > > first)")
>
> > > 'turns it into proper letters
> > > Newuser = Application.Proper(Newuser)
>
> > > 'Check to see if cancel button is pressed go back to Menu
>
> > >     If Newuser = "" Then
> > >         Sheets("Menu").Select
> > >        Exit Sub
>
> > >     End If
>
> > > 'Routine to check if Newuser already exists in list of users
>
> > >      '
>
> > > 'Find last row
>
> > > Set SrcSht = Sheets("UserList")
>
> > > nextRow = SrcSht.Cells(Cells.Rows.Count, "A").End(xlUp).Row + 1
>
> > > Application.ScreenUpdating = False
>
> > >     Range("A" & nextRow).Select
>
> This line will probably cause problems. Note that the Range function
> is invoked on the ActiveWorksheet if you don't specify a worksheet.
> You should transform these lines in such a way that you get rid of any
> Active calls (those Activate calls are a giveaway that the original
> code was recorded by the macro recorder ;-)
>
> The replacement code should look like this:
>   dim CurrentCell as Excel.Range
>   set CurrentCell = SrcSht.Cells(1,1)
>
>   ' Search the list of the new user name: This assumes that
>   ' there are no empty rows in the list of users.
>   While CurrentCell <> "" and CurrentCell <> Newuser
>     Set CurrentCell = CurrentCell.Offset (1,0)
>   Wend
>
>   if CurrentCell = NewUser then
>     Msgbox "The user is already present in the list!"
>     exit sub
>   end if
>
> > >     ActiveCell.FormulaR1C1 = Newuser
> > >         Columns("A:A").Select
> > >     Selection.Sort Key1:=Range("A2"), Order1:=xlAscending,
>
>  _
>
>
>
> > >                    Header:=xlGuess, OrderCustom:=1, _
> > >                    MatchCase:=False, Orientation:=xlTopToBottom, _
> > >                    DataOption1:=xlSortNormal
>
> > >     Application.ScreenUpdating = True
>
> > >     'display message to show that it has been added to userlist
> > >     MsgBox (Newuser & " has been added to List of Users")
>
> > >  'return to menu page
> > >     Sheets("Menu").Select
> > > End Sub
>
> > > The problems are as follows:-
>
> > > 1.  I have just added the code to check to see if the cancel button is
> > > pressed but it does not exit the subroutine - it adds a false to the
> > > list of users.
>
> > > 2.  How do I check to see if the Newuser entry already exists in the
> > > list of users
>
> > > 3.  The routine seems to work when running it from the VBA window but
> > > when the macro is attached to a button on the "Menu" Wrksheet it fails
> > > to add the name to the list of users.  This routine worked up until a
> > > few days ago and it really has me stumped
>
> > > Any help would be appreciated
>
> > > Brian
> > > Scotland
>
> Regards,
> Stuart

-- 
--
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

$$Excel-Macros$$ Sales Dash Boards

2011-02-16 Thread johnson john

Dear Members,

Can  any one Pls. share few Excel Sales Dash Boards? It would be of great
help to me in my day in and day out professional life.

 Best Regards.,
Johnson CA

-- 
--
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$$ 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 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$$ A little OT

2011-02-16 Thread Dave Bonallack


Hi Paul,
Thanks for the detailed info. Not too wordy at all. I hadn't realised that 
there were 2 different syntaxes (syntii?) - Sheets(1) and Sheet1. That makes 
sense now.
So then Sheets(1).Name will always return something, (though not always what 
you'd expect) because it is just the first sheet in the sheets array. But 
Sheet1.Name may produce an error, because Sheet1 may have been deleted.
The code line that I quoted (Sheets(Sheets.Count).Select) always works because 
it is using the sheets array, not the sheet name or the sheet object.
Thanks again. All very valuable knowledge.
Regards - Dave. 


Date: Tue, 15 Feb 2011 05:00:59 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ A little OT
To: excel-macros@googlegroups.com






The biggest confusion here is the difference between
the Worksheet OBJECT: Sheet1 
the Worksheet NAME:   Sheet1
and Sheets ARRAY: Sheets(1)
 
An Excel workbook must contain at least one sheet.
Excel will INTERNALLY "Identify" this sheet object as "Sheet1"
and will initially NAME the sheet "Sheet1"
 
But these are two different things.
 
In the VB Editor Object Explorer, you'll see:
Sheet1(Sheet1)
 
Meaning that the Sheet1 object is NAMED "Sheet1"
The key here is that Sheet1 can be NAMED anything, 
but will always be Sheet1 as long as it exists.
  
You can name your dog "kitty" but that doesn't change the fact that it's still 
a dog.
 
That's why you can use:
Sheet1.Name = "DataSheet"
The Name Property of the Sheet1 Object is set to "DataSheet"
 
So, even though the VB Object Explorer shows:
Sheet1(DataSheet)
You cannot use:
DataSheet.Select
 
Because "DataSheet" is not an Object...
 
Now, the Sheets() Array...
It's exactly that.
It's an array of sheet objects.
The interesting thing here is that the position in the array is
dependent upon where the sheet appears in the workbook.
 
If you have three sheets, Named: "Name1", "Name2" and "Name3"
and they were originally created in numerical order and positioned 
left-to-right.
The Sheets() Array will have them listed as:
Sheets(1).Name = "Name1"  
Sheets(2).Name = "Name2"
Sheets(3).Name = "Name3"
and the VBA Object Explorer will show them as:
Sheet1(Name1)
Sheet2(Name2)
Sheet3(Name3)
 
But if you move Name3 to the far left, so they're shown as:
"Name3", "Name1", "Name2"
 
The Object Explorer will still show them as:  
Sheet1(Name1)
Sheet2(Name2)
Sheet3(Name3)
 
But the Sheets ARRAY will be:

Sheets(1).Name = "Name3"  
Sheets(2).Name = "Name1"
Sheets(3).Name = "Name2"
 
BTW: The Sheets Array also has the "internal" name as the "CodeName" object.
 
 So.. summarize...
There are three distinct ways to identify a sheet (maybe more?)
The Sheet  OBJECT, 
the Sheet  NAME, and 
the Sheets ARRAY
 
You cannot change the "codeName" of an existing sheet object.
You CAN (of course) change the Sheet Name,
and the Sheets ARRAY is changed by the position of the sheet in the workbook.
 
In answer to your question.. Your question contains syntax errors.
Because when you say there are 7 sheets, but Sheet(7) doesn't exist.
You mean that Sheet7 doesn't exist... Sheets(7) is the 7th element of the Sheets
ARRAY, which DOES exist.
 
Does that help? or was it so "wordy" that you fell asleep midway and woke up
with a keyboard imprint on your right cheek?
 
Paul
 

 

 




From: Dave Bonallack 
To: "excel-macros@googlegroups.com" 
Sent: Mon, February 14, 2011 11:33:24 PM
Subject: $$Excel-Macros$$ A little OT



Hi Paul,
I have also noticed that after deleting and creating sheets, the Sheet numbers 
are out of order, and can be missing altogether. ie in a workbook of 7 sheets, 
one of them may be Sheet(11), while sheets 8 and 9 are not present at all.
So, my question is, why does this line of code (Sheets(Sheets.Count).Select) 
always select the last sheet in a workbook, even when the last sheet isn't 
necessarily the one with the highest sheet number, and also, if the sheet.count 
is say, 7, the thing still works if Sheet(7) doesn't exist!
Regards - Dave

 


Date: Mon, 14 Feb 2011 19:07:28 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not 
sheet with index2
To: excel-macros@googlegroups.com





In your VBA Object Explorer, you'll see 
Sheet1(Name1)
Sheet2(Name2)
Sheet3(Name3)
 
If you delete the sheet named "Name2", create a new sheet, and call the NEW 
sheet "Name2"
It won't be:
Sheet2(Name2), it'll be:
Sheet4(Name2).
 
So the LIST will be:
Sheet1(Name1)
Sheet3(Name3)
Sheet4(Name4)
 
in VBA the Sheets array is:
Sheets(1).Name = "Name1"
Sheets(2).Name = "Name3"
Sheets(3).Name = "Name2"
 
Because the Sheets() array is a list of sheet names.
An odd occurence though is: 
If you save and exit Excel, open the file,
and create a new Sheet (Name4)
it will create it as:
Sheet2(Name4)
and the array becomes:

Sheets(1).Name = "Name1"
Sheets(2).Name = "Name4"
Sheets(3).Name = "Name3"
Sheets(4).Name = "Name2"
 
So, basically, when you see "sheet1", "sheet2", etc in the VBA Project 
Ex

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

2011-02-16 Thread ashish koul

use this


IF(MIN(G2:K2)=0,SMALL(G2:K2,COUNTIF(G2:K2,0)+1),MIN(G2:K2))

On Wed, Feb 16, 2011 at 2:42 PM, Vj Realsaggi  wrote:

> Dear Team,
>
> Kindly go through Attached Xl,
>
> In category Column i insert nested if formula, which give me minimum Column
> Values comparing "Sum of Quantity " To 5 other Column.
>
> Regards
> Vijay
>
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

$$Excel-Macros$$ help me regarding copy only conditional formating with formula & extending formula.

2011-02-16 Thread Nuria Gimenez

Dear all,


In a big table I need that *all cells* changes it color,  depending formula
,

cell under study (file, row)

*if (*row*$20="c";$F*file*;$G*file*) *

I want to extend the conditional format to all the table but without change
all the other formants,


Thanks and best regards




-- 
Nuria

-- 
--
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

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

2011-02-16 Thread Vj Realsaggi

Dear Team,

Kindly go through Attached Xl,

In category Column i insert nested if formula, which give me minimum Column
Values comparing "Sum of Quantity " To 5 other Column.

Regards
Vijay

-- 
--
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


NEED sOL.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: error checking VBA Excel 2003

2011-02-16 Thread Stuart Redmann

> On Feb 15, BJthebear wrote:
> > I have written a sub routine to add a name to a dynamic list but I
> > have three problems with it and would be grateful for some advice.
> >
> > Sub InputNewUser()
> >
> > Dim Newuser As String
> > Dim nextRow As Long
> >

[snipped some code]

> > 'Ask for name of new user
> >
> > Newuser = Application.InputBox("Please enter name of new user (Surname
> > first)")
> >
> > 'turns it into proper letters
> > Newuser = Application.Proper(Newuser)
> >
> > 'Check to see if cancel button is pressed go back to Menu
> >
> > If Newuser = "" Then
> > Sheets("Menu").Select
> >Exit Sub
> >
> > End If
> >
> > 'Routine to check if Newuser already exists in list of users
> >
> >  '
> >
> > 'Find last row
> >
> > Set SrcSht = Sheets("UserList")
> >
> > nextRow = SrcSht.Cells(Cells.Rows.Count, "A").End(xlUp).Row + 1
> >
> > Application.ScreenUpdating = False
> >
> > Range("A" & nextRow).Select


This line will probably cause problems. Note that the Range function
is invoked on the ActiveWorksheet if you don't specify a worksheet.
You should transform these lines in such a way that you get rid of any
Active calls (those Activate calls are a giveaway that the original
code was recorded by the macro recorder ;-)

The replacement code should look like this:
  dim CurrentCell as Excel.Range
  set CurrentCell = SrcSht.Cells(1,1)

  ' Search the list of the new user name: This assumes that
  ' there are no empty rows in the list of users.
  While CurrentCell <> "" and CurrentCell <> Newuser
Set CurrentCell = CurrentCell.Offset (1,0)
  Wend

  if CurrentCell = NewUser then
Msgbox "The user is already present in the list!"
exit sub
  end if



> > ActiveCell.FormulaR1C1 = Newuser
> > Columns("A:A").Select
> > Selection.Sort Key1:=Range("A2"), Order1:=xlAscending,
 _

> >Header:=xlGuess, OrderCustom:=1, _
> >MatchCase:=False, Orientation:=xlTopToBottom, _
> >DataOption1:=xlSortNormal
> >
> > Application.ScreenUpdating = True
> >
> > 'display message to show that it has been added to userlist
> > MsgBox (Newuser & " has been added to List of Users")
>
> >  'return to menu page
> > Sheets("Menu").Select
> > End Sub
>
> > The problems are as follows:-
>
> > 1.  I have just added the code to check to see if the cancel button is
> > pressed but it does not exit the subroutine - it adds a false to the
> > list of users.
>
> > 2.  How do I check to see if the Newuser entry already exists in the
> > list of users
>
> > 3.  The routine seems to work when running it from the VBA window but
> > when the macro is attached to a button on the "Menu" Wrksheet it fails
> > to add the name to the list of users.  This routine worked up until a
> > few days ago and it really has me stumped
>
> > Any help would be appreciated
>
> > Brian
> > Scotland

Regards,
Stuart

-- 
--
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$$ RASHI QUERRY

2011-02-16 Thread Prakash Gusain

=VLOOKUP(IF(SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))>K8,SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))-
K8,SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))),A3:C15,3,TRUE)

On Feb 15, 8:47 pm, ashish koul  wrote:
> VLOOKUP(IF(VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)>=
> 1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)-1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)),$A$2:$C$15,3,1)
>
>
>
> On Tue, Feb 15, 2011 at 4:43 PM, Nemi Gandhi  wrote:
> > Thank you Mr. sundervalen, but i need only one formula instead of
> > calculating value for date, month and time separately,. Is it
> > possible?
> > and thank you to Mr. Ashish kaul also for help.
>
> > On Feb 14, 8:42 pm, Sundarvelan N  wrote:
> > > Check if mine is ok for you
>
> > > Thanks,
> > > Sundarvelan,
> > > 9600160150
>
> > > On Mon, Feb 14, 2011 at 8:08 PM, ashish koul 
> > wrote:
> > > > see if it helps
>
> > > > On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi 
> > wrote:
>
> > > >> attached herewith rashi querry sheet. Please provide me formula and
> > help.
>
> > > >> --
> > > >> 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
>
> > > > --
> > > > *Regards*
> > > > * *
> > > > *Ashish Koul*
> > > > *akoul*.*blogspot*.com 
> > > > *akoul*.wordpress.com 
> > > > My Linkedin Profile 
> > > > 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 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
> > > N.Sundarvelan
> > > 9600160150
>
> > >  Xl002.xls
> > > 41KViewDownload
>
> > --
>
> > --
> > 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
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
> 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

<><><><><><><><><><><><><><><><><><><><><><>

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-16 Thread Nemi Gandhi

Thank you very much Aashishbhai...incredible!
nemi

On Feb 15, 8:47 pm, ashish koul  wrote:
> VLOOKUP(IF(VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)>=
> 1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)-1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)),$A$2:$C$15,3,1)
>
>
>
> On Tue, Feb 15, 2011 at 4:43 PM, Nemi Gandhi  wrote:
> > Thank you Mr. sundervalen, but i need only one formula instead of
> > calculating value for date, month and time separately,. Is it
> > possible?
> > and thank you to Mr. Ashish kaul also for help.
>
> > On Feb 14, 8:42 pm, Sundarvelan N  wrote:
> > > Check if mine is ok for you
>
> > > Thanks,
> > > Sundarvelan,
> > > 9600160150
>
> > > On Mon, Feb 14, 2011 at 8:08 PM, ashish koul 
> > wrote:
> > > > see if it helps
>
> > > > On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi 
> > wrote:
>
> > > >> attached herewith rashi querry sheet. Please provide me formula and
> > help.
>
> > > >> --
> > > >> 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
>
> > > > --
> > > > *Regards*
> > > > * *
> > > > *Ashish Koul*
> > > > *akoul*.*blogspot*.com 
> > > > *akoul*.wordpress.com 
> > > > My Linkedin Profile 
> > > > 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 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
> > > N.Sundarvelan
> > > 9600160150
>
> > >  Xl002.xls
> > > 41KViewDownload
>
> > --
>
> > --
> > 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
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
> 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

$$Excel-Macros$$ Please help in P Table.

2011-02-16 Thread anil panchal

Dear All,

my Question is we can use use two header in p. Table.?

-- 



Thanks & Regards
Anil Kumar

-- 
--
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$$ Need Solution Nested If Formula

Re: $$Excel-Macros$$ Match and index formula help required

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

Re: $$Excel-Macros$$ data in horizontal row

Re: $$Excel-Macros$$ columns into rows, with a twist

Re: $$Excel-Macros$$ Dynamic range

$$Excel-Macros$$ How to Get Filtered Data from SQL server into Microsoft Excel 2007

$$Excel-Macros$$ columns into rows, with a twist

Re: $$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

Re: $$Excel-Macros$$ Query

$$Excel-Macros$$ Excel Templates on Call forecasting

Re: $$Excel-Macros$$ Query

Re: $$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Load image from the url

Re: $$Excel-Macros$$ Nos. of Sundays between two days

Re: $$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

Re: $$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

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

Re: $$Excel-Macros$$ Match and index formula help required

Re: $$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

$$Excel-Macros$$ Select data from sheet2 to sheet1 which is not exist in the sheet1

$$Excel-Macros$$

Re: $$Excel-Macros$$ Nos. of Sundays between two days

Re: $$Excel-Macros$$ Sales Dash Boards

$$Excel-Macros$$ Re: error checking VBA Excel 2003

$$Excel-Macros$$ Sales Dash Boards

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

RE: $$Excel-Macros$$ A little OT

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

$$Excel-Macros$$ help me regarding copy only conditional formating with formula & extending formula.

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

$$Excel-Macros$$ Re: error checking VBA Excel 2003

Re: $$Excel-Macros$$ RASHI QUERRY

Re: $$Excel-Macros$$ RASHI QUERRY

$$Excel-Macros$$ Please help in P Table.

36 matches

Site Navigation

Mail list logo

Footer information