me also send pleasvikask...@gmail.com
On Thu, May 13, 2010 at 11:22 AM, Nani Ram <06n...@gmail.com> wrote:
> Hi Excel Masters,
>
> Could any one have MS-Excel Bible by john walkenbach e-book.
> if so could please send it to me at 06n...@gmail.com.
>
>
> Thanks in advance,
>
> Nani
Hi Anil,
Can we have macro editing password? It will be help a lot, how the funtions
are built in.
Regards,
Ajay N
On Fri, May 14, 2010 at 9:27 AM, Aindril De wrote:
> Hi Rajesh,
>
> A nice one for quick reference...
> Thanks buddy
>
> Regards,
> Andy
>
> On Fri, May 14, 2010 at 12:33 AM, Ra
Hi Rajesh,
A nice one for quick reference...
Thanks buddy
Regards,
Andy
On Fri, May 14, 2010 at 12:33 AM, Rajesh Nair wrote:
> Hi All,
>
> Please find attached Excel formula book .
> This may help.
>
> Regards,
> Rajesh. Nair
>
> --
>
> -
Hi,
What do you want to achieve by sorting?
Dave.
> Date: Thu, 13 May 2010 11:01:13 -0700
> Subject: $$Excel-Macros$$ Sort data in two nonidentical columns
> From: eller.n...@gmail.com
> To: excel-macros@googlegroups.com
>
> We have an Excel list with 3 columns. In the first column is the
> c
Hi Excel Masters,
Could any one have MS-Excel Bible by john walkenbach e-book.
if so could please send it to me at 06n...@gmail.com.
Thanks in advance,
Nani Ram
--
--
Some important links for excel users:
1. Follo
We have an Excel list with 3 columns. In the first column is the
client name, second column is their email address (the full newsletter
list) and the third column is a list of nonprofits on our email list.
Nick 1
Jerry 2 2
Tom 3 3
Bill4
Does anyone have a
Thanks for the code... I am trying it out it all makes sense to me,
except "UCase" -- what is it? It's not a function... and when I run this
code , nothing happens -- can you explain a little more? Sorry, but I am a
novice...
On Wed, May 12, 2010 at 6:55 PM, siti Vi wrote:
> Sub Bla_Bla_Bla(
Hi Mike,
Is this the original formula?
=IF(SUM(IF('Test Plan'!$I$13:$I$10134="NB",1,0))>0,SUM(IF('Test
Plan'!$I$13:$I$10134="NB",1,0)),0)+IF(SUM(IF('Test
Plan'!$I$13:$I$10134="QU",1,0))>0,SUM(IF(TestPlan!$I$13:$I$10134="QU",1,0)),0)+IF(SUM(IF('Test
Plan'!$I$13:$I$10134="SLIQ",1,0))>0,SUM(I
Thanks a lot Vigooo. You have solved my problem. Thanks again and again.
AZHAR RAI
Cell: 0333-552-7731
Skype: azhar.rai
On 13 May 2010 10:10, Vigooo wrote:
> to make it precise,
>
>
>
> =if(ISERROR(SEARCH(" ",A1)),LEN(A1),SEARCH(" ",A1)-1)
>
>
>
>
>
> With best regards,
>
> Vignesh
>
>
>
> *F
Dear Harry,
when i used the same formula in diff excel sheet it not work properly, i
have attached sheet. please help.
Is there any settings? Please reply, it will reduce my lots of work.
thank you,
Jitendra
On Wed, May 12, 2010 at 11:20 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> w
Dear Harry,
when i used the same formula in diff excel sheet it not work properly, i
have attached sheet. please help.
Is there any settings? Please reply, it will reduce my lots of work.
thank you,
Jitendra
On Wed, May 12, 2010 at 11:20 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> w
formula :
=CONCATIF($A$2:$A$18,D2,$B$2:$B$65)
vba code of ConcatIf UDF :
Function ConcatIf(Rang1 As Range, Crite As Range, _
Optional Rang2 As Range = Nothing, _
Optional Dlmtr As String = "; ") As String
'---
' siti Vi / UDF CONDITIONA
Hi Siti,
Thanks for your reply,
But the below said is not working
Below is the recorded code for removing pagebreaks
ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1
is any other code to remove page breaks
*I need to set the Page break to end of the used last column.*
*
to make it precise,
=if(ISERROR(SEARCH(" ",A1)),LEN(A1),SEARCH(" ",A1)-1)
With best regards,
Vignesh
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dave Bonallack
Sent: Wednesday, May 12, 2010 3:59 PM
To: excel-macros@googlegroups.com
Subject
14 matches
Mail list logo
