Select the function and press tab.
Thanks & Regards
Sandeep
On Thu, May 6, 2010 at 11:38 PM, Michael wrote:
> I posted a picture of what I'm trying to discover:
>
>
> http://excel-macros.googlegroups.com/web/5-6-2010%2010-30-03%20AM.png?gsc=KEUGpSMAAABiUNuXkcp8v73inTrP5WRB6rVQQoo7NfTRwCUKHBmr86
Hello I´d like to send more than on attachment using the mothod
".attachment.add"
For exemplo all pictures from on certain directory.
Thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWI
www.tudosobrexcell.com
2010/5/6 nagendra baral
> Hi There
>
> Please send some website links which can be helpful in learning Excel
> VBA and downloading Ebooks.
>
> Thanks and Regards
> Nagendra
> I
>
> --
>
> --
I posted a picture of what I'm trying to discover:
http://excel-macros.googlegroups.com/web/5-6-2010%2010-30-03%20AM.png?gsc=KEUGpSMAAABiUNuXkcp8v73inTrP5WRB6rVQQoo7NfTRwCUKHBmr860IoyLhPG2x5smOr2otMGI
Does anyone know of a shortcut to select from the drop down of
suggested terms when creating a f
Use the function RIGHT(Select the whole text in which the textor the thing
which you want is there,number of characters which you want from the text)
Ex: If a Cell B2 ContainsTIGER999 .Use the function = RIGHT(B2,3) to get
the required 999 as the answer.
On Thu, May 6, 2010 at 9:
Dvpetta,
Can you upload a 2003 version, i may be able to give a thought on it
CC me in, so that i know that you have uploaded the sheet
Cheers
Harry
On May 4, 8:27 pm, dza7 wrote:
> Hello,
>
> I have a challenging pivot table issue that I hope I can get some help
> on.
>
> Here is the spreads
Public Function exright(Str)
Dim i, NumStr1
NumStr1 = ""
For i = Len(Str) To 1 Step -1
If (Mid(Str, i, 1)) <> " " Then
NumStr1 = Mid(Str, i, 1) & NumStr1
Else
Exit For
End If
Next i
exright = NumStr1
End Function
On Thu, May 6, 2010 at 6:15 PM,
Format Start Date and End Date cells using custom format (d.mm.)
Start Date (A1
Number of Days (B1)
End Date (C1)
C1 contains =A1+B1
Maggie
On May 6, 6:13 am, dare2gold wrote:
> Dear Members,.,
>
> i want to know how to get a later date just by inserting present date
> into one column and
Hi There
Please send some website links which can be helpful in learning Excel
VBA and downloading Ebooks.
Thanks and Regards
Nagendra
I
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips t
Hi Friends,
Please help me to delete the date which are older than last week wednesday.
Also i need a code to remove page breaks except the below recoded code
ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1
Thanks
N.Sundarvelan
--
-
Please help out. I got struct here.
On Thu, May 6, 2010 at 5:45 PM, anand shivappa wrote:
> Hi Everyone,
>
> I need to extract a rightmost word in a line through excel functions.
>
> Like USA Street is having no 10. I need to extract the last word like 10.
>
> Please help me out.
>
>
> Thanks
Hi Everyone,
I need to extract a rightmost word in a line through excel functions.
Like USA Street is having no 10. I need to extract the last word like 10.
Please help me out.
Thanks and Regards,
Anand S
--
When everything fails Patience will win
--
-
Dear Members,.,
i want to know how to get a later date just by inserting present date
into one column and getting the date we desire just by typing the no
of days
suppose i entered 1.04.2010 29days the output should be 30.04.2010.
please tell me ...
thanks in anticipations
goldie
--
-
Hi Rajeev,
Attached file has been solved as per your requirements.
Get back to me in case of any issues.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Wed, May 5, 2010 at 1:10 AM, Raje
USE THIS ONE
=VLOOKUP(C6,INDIRECT(B6&"!A:I"),2+MATCH('Inv for
Rate'!D6,INDIRECT(B6&"!$C$2:$I$2"),0),0)
Inv for Rate'!D6, specifies the value of cell d6 of sheet name Inv for
Rate'
On Thu, May 6, 2010 at 11:48 AM, vidyut more wrote:
> Thnaks for ur sollution. I have given sample ,anybody has
On Thu, May 6, 2010 at 12:35 PM, Rajeev Nandan wrote:
> Hi All,
> Can you help and guide me to understand Works Contract Tax with concept
> and working..
> Regards,
> Rajeev Nandan
>
--
--
Some important links for ex
Hi All,
Can you help and guide me to understand Works Contact Tax with concept
and working..
Regards,
Rajeev Nandan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
Hi Dheeraj,
Thanks for asking. Here is the explanation.
=SUMPRODUCT((Sheet1!$B$2:$B$25=Sheet2!$A2)*(Sheet1!$A$2:$A$25=(MIN(IF(Sheet1!$B$2:$B$25=Sheet2!A2,Sheet1!
$A$2:$A$25,"",Sheet1!$C$2:$C$25)
SumProduct formula acts as a array formula and it is very powerful function
which Excel has in it
Dear can you please tell me how to change the extention from txt to exe.
thanks
AZHAR RAI
Cell: 0333-552-7731
Skype: azhar.rai
On 5 May 2010 19:58, sudhir kumar wrote:
> i attached the folder lock software, u install it , it is very good for
> folder lock.
> first change the extension to .exe
Thnaks for ur sollution. I have given sample ,anybody has formula for
to many parties and rate is different for each party i want to know.
On Thu, May 6, 2010 at 10:19 AM, Hitesh Dilipbhai Dhare
wrote:
> Can you tell me, what is the meaning of following argument in the solution
> provided?
>
>
>
20 matches
Mail list logo
