Hi,
Check the attached file and let me know if its ok for you
Regards
Sathish Jalendran
Picture (Device Independent Bitmap)
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of C Vivek
Sent: 26 March 2010 PM 04:52
To: excel-macros@googlegroups.com
Dear Group,
Is it possible to trigger a macro on a specified date , even if that excel
file is not opened
Regards
Sathish Jalendran
The information contained in this electronic message and any attachments to
this message are intended for the exclusive
use of the addressee(s
Hi,
In excel 2003 the filter will show only the first 1000 results hence you
are not able to view data beyond 1000(but custom filters will work), where
as this problem will not be there in excel 2007,
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac
Hi,
Please check if the attached solution suits you
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of amresh kumar
Sent: 03 September 2009 PM 02:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Count if i
Hi,
Check the attached file
1 u have to freeze cells in the formula
2 you have to convert to numbers before applying the formula
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mahesh
Sent: 28 August 2009 PM 12:08
+ --Cracked by Sathish Jalendran, Title:=Split Data,
Default:=A1, Type:=8)
'for selecting the criteria range
Set subrnge = Application.InputBox(prompt:=Select the Column/Sub Data Range
based on which the Data will split? + vbCrLf + Note: Ensure you select
Column Heading Too and Ensure there are no blank
Hi,
U can try this
=SUMIF(E4:E8,0,E4:E8)
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ANIL NAIR
Sent: 07 August 2009 PM 02:09
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent - How to calculate
U can do control+shift+enter instead of normal enter
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ashish Pradhan
Sent: 07 August 2009 PM 02:46
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: urgent - How
Hi,
Right click on the merge field and do toggle fieldcodes and insert the
follow after the mergefield(as shown below) \#00 u will not get any
decimal value
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Deep
Sent
Hi,
Use text to column wizard in 3rd step select date and DMY format all your
dates will be converted to data format
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of sachin patil
Sent: 13 July 2009 PM 03:00
To: Excel
Hi,
If you are using office 2007 you can use countifs function else u can use
formula like below
=COUNTIF(A2:A8,mumbai)+COUNTIF(A2:A8,delhi)
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of amresh kumar
Sent: 09 July
Hi,
One possible solution is u can paste this data in to MS word and then do a
find * and replace this works
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of amresh kumar
Sent: 06 July 2009 10:51 am
To: excel-macros
Hi,
Please check the attached solution, let me know if it solves your query.
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of TERTIUS KOSHY THOMAS
Sent: 29 June 2009 06:52 am
To: excel-macros@googlegroups.com
Subject
This is something really new thanks for the same
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Rajesh Kunder
Sent: 19 June 2009 09:27 am
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ BEST EXCEL TIP WEEK
Hi,
Please check if the attached solution suits your need
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Sachin Shukla
Sent: 03 June 2009 10:43 am
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help
Hi,
Check the attached formula this works only if the Sub Cat is sorted
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mayank Patel
Sent: 27 April 2009 06:54 pm
To: excel-macros@googlegroups.com
Subject: $$Excel
U can download the Compatibility pack and u can retrieve the data
http://office.microsoft.com/en-us/products/HA101686761033.aspx
Regards
Sathish Jalendran
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of raafi barey
Sent: 24
Hi,
Check attached file
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Putta Madaiah
Sent: 20 April 2009 05:33 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ All the names copied to one Cell seperated
Hi,
Please check the attached,
Have done it thru validation Colum B:B can be hidden if required
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of anil kumar
Sent: 07 April 2009 01:31 pm
To: excel-macros
Hi,
You can try doing past special values this retain the validations
Regards
Sathish Jalendran
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of xmux
Sent: 18 March 2009 06:14 pm
To: MS EXCEL AND VBA MACROS
Subject: $$Excel
Hi,
Please check and let me know if the attached solution is ok
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Pooja Sharma
Sent: 17 February 2009 02:38 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros
U can use find and replace..
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Sachin N Harale
Sent: 05 February 2009 02:12 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to filter , from data in cell
Hi,
Check if the attached formula works for you
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Rabindra Thapa
Sent: 03 February 2009 08:10 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help-Excel
Hi,
Check the attached file let me know if its fine
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Chaudhry Zahid Ali
Sent: 29 January 2009 09:17 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Date
You can use a sumproduct function for this
Regards
Sathish Jalendran
-Original Message-
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]
Sent: 03 December 2008 09:50 am
To: MS Excel VBA Macros
Subject: $$Excel-Macros$$ Count function
I
=TEXT(A1,ddd)
This will give u the day
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of Mayank Patel
Sent: 14 October 2008 10:22 am
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Can I get Day from date in excel.
Hi
26 matches
Mail list logo