Thanks a lot!
>
> Regards
>
> Anton Mulder
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> >
>
--
Srinivasan Ethirajalu,
+91-9449279330
--~--~-~--~~~---~--~~
V
below:
=$C3=$D$2 then clicked in Format > border > outine & Patterns > click on
light yellow color as background color. Click 'ok'
5) Went to cel b2, click on format paint & applied to entire col B.
Enjoy.
On Fri, Jan 30, 2009 at 11:23 PM, Srinivasan Ethirajalu
; non blank cells). but I want copying only non blank cells(cells
> having data) from that column. Could somebody help me in writing a macro for
> this.
>
> Regards
>
> Debasish Sahu
> Assistant Manager - Geology
> ACC Ltd.
> Thane - 400 604
>
ensome
> kindly help me out
>
> >
>
--
Srinivasan Ethirajalu,
+91-9449279330
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
F
To select blank cells in a range:
Select the range, then hit *Cntl + G* > *Alt + S* (special) >* k* (blanks) >
hit *enter*.
Srinivasan Ethirajalu.
On Fri, Jun 5, 2009 at 8:53 PM, ayush jain wrote:
> Hello Everyone,
>
> We are launching a weekly "BEST EXCEL TIP AWARD&quo
To select blank cells in a range:
Select the range, then hit Cntl + G > Alt + S (special) > k (blanks) > hit
enter.
Srinivasan Ethirajalu.
On Sat, Jun 6, 2009 at 1:13 PM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:
> Hi all,
>
>
> Name : Manoj S Negi
> S
n each month.
>
> I went through manually and checked the cells that were for the
> beginning /ending of the months and wrote:
>
>
> =COUNTIFS(dates,"<11/1/2008",dates,">9/30/2008")
>
> is there a way to do wit
pls find the attachment...
Srinivasan E
On Thu, Jul 16, 2009 at 6:56 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Do you want number of records for each months...
>
> Srinivasan E
>
>
>
> On Wed, Jul 15, 2009 at 10:45 PM, faheem3
Merge the Male & Female sheet. And fill the empty cell will correct values
for
*Cat'y*
*Pincode* *Area*
And use Pivot tabale for getting subset of the search critiria.
if you don't know the Pivot table, please search in net & explore yourself.
thanks
Srinivasan Ethirajalu
Use pivot table, use# column in ROW area & Date in DATA area, change "Count
of Date" to "Max of Date", format the data area to date format. Then "Hide"
the grand total.
Srinivasan Ethirajalu
On 8/5/10, Nadine S wrote:
>
> Sheet 1 contains
> #
# Date Max of Date 1001 8/2/2010 # Total 1001 6/10/2010 1001
8/2/2010 1001 3/14/2010 2355 4/12/2010 1001 3/1/2010 5252 3/15/2010 1001
2/15/2010 1001 2/15/2010 2355 4/12/2010 2355 1/6/2010
5252 3/15/2010 5252 2/15/2010 5252 1/6/2010
On 8/6/10, Srinivasan Ethirajalu wrote
pivot table and I'd be done but it just won't work in this case.
>
>
> ------
> *From:* Srinivasan Ethirajalu
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, August 5, 2010 7:59:53 PM
> *Subject:* Re: $$Excel-Macros$$ Need max date
>
om
> 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
>
> <><><><><><><><><><><><><><>
t;<><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
>
ked out.
>
>
> One Love...
>
> On Thu, Sep 23, 2010 at 12:28 PM, Srinivasan Ethirajalu <
> srinivasan.ethiraj...@gmail.com> wrote:
>
>> Step1: Use additional columns as Test1 & test 2 in Column H & I
>> Step2: Add the Below formula to H2
>>
;><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
;>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
-
please find the excel with result of 3 column comparision:
i have checked for isblank formula & assigned with weightage as 1,2,4 for
col a,b,c
On Fri, Sep 24, 2010 at 10:40 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Please clarify:
> Below are a
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.blo
ip
> 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
t;<><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
Srinivasa
updated one
On Mon, Oct 11, 2010 at 10:41 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> refer the attachment
>
> Srinivasan
>
>
> On Mon, Oct 11, 2010 at 10:21 PM, Rajesh K R
> wrote:
>
>> HI ALL EXPERRTS
>>
>> IS THER
;><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
Srinivasan Ethirajalu,
+9198405442
this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/
ailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><>
s using a macro or formula.
>
> expecting your answer.
>
> regards
>
> rajesh
>
> On 10/11/10, Srinivasan Ethirajalu
> wrote:
> > updated one
> >
> >
> > On Mon, Oct 11, 2010 at 10:41 PM, Srinivasan Ethirajalu <
> >
On Thu, Oct 14, 2010 at 6:49 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> use =subtotal(9,your-range)
>
> Note: 9 stands for SUM
> Please check the help for other function-num in help file.
>
>
>
>
>
>
> On Thu, Oct 14, 2010 at
values
On Thu, Oct 14, 2010 at 6:53 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
>
>
> On Thu, Oct 14, 2010 at 6:49 AM, Srinivasan Ethirajalu <
> srinivasan.ethiraj...@gmail.com> wrote:
>
>> use =subtotal(9,your-range)
>>
>> No
On Thu, Oct 14, 2010 at 7:03 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Function_num
> (includes hidden values) Function_num
> (ignores hidden values) Function 1 101 AVERAGE 2 102 COUNT 3 103 COUNTA 4
> 104 MAX 5 105 MIN 6 106 PRODUCT 7 107 STDEV 8 10
Pls find the attachment
On Thu, Oct 14, 2010 at 1:10 PM, NOORAIN ANSARI wrote:
> Dear Srinivasan,
>
> Below formula is not working properly. We are unable to find valid output.
>
> Please suggest...
>
> Thanks,
> Noorain Ansari
>
> On Wed, Oct 13, 2010 at 1
ups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelco
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
>
>
t; >
> > > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > > <><><><><><><><><><><><><><><><><><
Enjoy
On Fri, Oct 22, 2010 at 6:26 PM, Gmail wrote:
> Yes the format for the date is yymmdd
> I am working with excel 97
>
> Sent from my Blackjack via AT&T
>
> On Oct 21, 2010, at 10:35 PM, Srinivasan Ethirajalu <
> srinivasan.ethiraj...@gmail.com> wrote:
>
---
> 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.
t; Now I have Another problem.
>> > > > For the same data I want to Find out Average,Min,Max
>> > > > I could manage for Average using Averageif but Min And Max I am not
>> > > getting
>> > > > showing (NA) value look at the attached sheet.
>> > >
>> 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 h
t;"), "Please check
the date(s)")
this will supress if year/month/day = 0 in the expansion. like
A1 => 12/20/2010 (in MM/DD/)
A2 => 11/12/2010
*Result===> 1 Month(s) , 8 Day(s) Left *
On Fri, Nov 12, 2010 at 9:53 PM, Srinivasan Ethirajalu <
srinivasan.ethi
<><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
Sr
ot;)
On Mon, Nov 15, 2010 at 11:14 AM, Manjunath C
wrote:
> Excellent one,,,its working
>
> Is it possbile , the result should be 0 , if i give same dates for both.
>
> On Fri, Nov 12, 2010 at 9:53 PM, Srinivasan Ethirajalu <
> srinivasan.ethiraj...@gmail.com> wrote:
>
l to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebo
for alphabets, have filter as "equal to *" & filter as "greater than 0" for
numerals
On Tue, Nov 30, 2010 at 7:09 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Have a filter "greater than 0"
>
>
> On Mon, Nov 2
-
> 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 tutori
com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><&
--
> 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=1871
ook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>
>> --
>>
>>
--
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips
-
>> 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.blogspo
-
> 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. Lear
-
> 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. Lear
49 matches
Mail list logo