email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Srinivasan Ethirajalu,
+919677042736
--
--
Some important links for excel
email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Srinivasan Ethirajalu,
+919677042736
--
--
Some important links for excel
--
Srinivasan Ethirajalu,
+919677042736
--
--
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
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Srinivasan Ethirajalu,
+919677042736
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
/discussexcel
--
Srinivasan Ethirajalu,
+919677042736
--
--
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
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Srinivasan Ethirajalu,
+919677042736
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu,
+919677042736
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu,
+919840544295
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 29, 2010 at 11:55 PM, Aamir Shahzad
aamirshahza...@gmail.comwrote
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:
=IF(A1 A2, IF(YEAR(A1)-YEAR(A2)0,YEAR(A1)-YEAR(A2) Year(s), ,)
IF(MONTH(A1) - MONTH(A2)0,MONTH(A1) - MONTH(A2
-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu,
+919840544295
--
--
Some important
/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.ethiraj...@gmail.com wrote:
=IF(A1 A2, IF(YEAR(A1)-YEAR(A2)0,YEAR(A1)-YEAR(A2) Year(s), ,)
IF(MONTH(A1) - MONTH(A2)0,MONTH(A1) - MONTH(A2
://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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu,
+919840544295
, Oct 22, 2010 at 12:39 PM, Srinivasan Ethirajalu
srinivasan.ethiraj...@gmail.com wrote:
Best answer is =na( )
@anandydr: Very talented answer. GOOD LUCK
*
*
On Fri, Oct 22, 2010 at 12:02 PM, anandydr anand...@gmail.com
wrote:
If we put =na
/discussexcelcom/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu,
+919840544295
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2
Enjoy
On Fri, Oct 22, 2010 at 6:26 PM, Gmail cdelano...@gmail.com wrote:
Yes the format for the date is yymmdd
I am working with excel 97
Sent from my Blackjack via ATT
On Oct 21, 2010, at 10:35 PM, Srinivasan Ethirajalu
srinivasan.ethiraj...@gmail.com wrote:
1)
PropertyID
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu,
+919840544295
@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu,
+919840544295
--
--
Some important links
of the filtered values using a macro or formula.
expecting your answer.
regards
rajesh
On 10/11/10, Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com
wrote:
updated one
On Mon, Oct 11, 2010 at 10:41 PM, Srinivasan Ethirajalu
srinivasan.ethiraj...@gmail.com wrote:
refer
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 12:26 AM, Rajesh K R
rajeshkainikk...@gmail.comwrote
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)
Note: 9 stands for SUM
Please check the help for other function
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 108 STDEVP 9 109 SUM 10
/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu,
+919840544295
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
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
rajeshkainikk...@gmail.comwrote:
HI ALL EXPERRTS
IS THERE ANY WAY TO FILTER THE DATA 1/10/10
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/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu
--
Srinivasan Ethirajalu,
+919840544295
--
--
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
@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Srinivasan Ethirajalu,
+919840544295
--
--
Some important links
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 all possibilities
at
http://groups.google.com/group/excel-macros/subscribe
--
Srinivasan Ethirajalu,
+919840544295
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
filter *and it worked 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
=A2C2D2
Step3: Add the Below formula to I2
@googlegroups.com
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
--
Srinivasan Ethirajalu
--
Srinivasan Ethirajalu,
+919840544295
--
--
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
and I'd be done but it just won't work in this case.
--
*From:* Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Thu, August 5, 2010 7:59:53 PM
*Subject:* Re: $$Excel-Macros$$ Need max date
# Date Max of Date
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 n8dine4ma...@yahoo.com wrote:
Sheet 1 contains
# Date 1001 03/01/10 5252 02/15/10
# 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
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
On 8/4/10, Maries
in 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 with vba?
--
Srinivasan Ethirajalu,
+91-9789090062
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 fahe...@gmail.com wrote:
I have
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 jainayus...@gmail.com wrote:
Hello Everyone,
We are launching a weekly BEST EXCEL TIP AWARD from today
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
Subject : Insert a new sheet in the excel
Orkut home My settings notifications Messages Uncheck email
On Fri, Feb 6, 2009 at 11:53 AM, rahul jain 5190ra...@gmail.com wrote:
I want to dejoin the group how can i do that.
daily i receive 10- 15 mails from the group which is so burdensome
kindly help me out
--
Srinivasan
). 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
India
--
Srinivasan Ethirajalu,
+91-9449279330
--
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
For more options, visit this group at
http://groups.google.com
:
=$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
srinivasan.ethiraj...@gmail.com wrote
44 matches
Mail list logo