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) and
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
Hi,
Check the attached formula, and let me know if this is what u r looking for
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of vinod rao
Sent: 26 August 2009 PM 03:53
To: excel-macros@googlegroups.com
Subject: $$Excel
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,
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$$ ur
Column Heading Too." + vbCrLf +
vbCrLf + "-->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
Hi,
Check this one if its ok for u
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Putta Madaiah
Sent: 04 August 2009 PM 02:39
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula-Replacing Minus Symbol
Hi,
Please check the attached excel
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mahesh
Sent: 23 July 2009 PM 12:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Duplicate colmuns
Hi vivek
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 Beha
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
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]
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
Hi,
Save the add in file in the excel start up location (see below) and restart
your excel and use the following formula "=ntow(Cell reference)"
C:\Users\[user]\AppData\Roaming\Microsoft\Excel\XLSTART
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [ma
figure or cell reference
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Shiv Pratap
Sent: 21 June 2009 06:43 pm
To: excel-macros@googlegroups.com
Cc: megaliving_corporat...@yahoo.com; megaliving.corporat...@gmail.com
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$$Options
Hi
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
You can try Sumproduct
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Nidhesh Dhawan
Sent: 29 May 2009 02:28 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ SUMIF for multiple conditions
Hi,
Can any
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,
This is possible thru conditional formatting
Regards
Sathish Jalendran
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ExcelUser777
Sent: 12 March 2009 05:21 pm
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ COLOR
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 da
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
Hi,
Please check the below mentioned link i think it will be useful for you
http://www.slideshare.net/djakelic/howto-mail-merge-with-lotus-notes/
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of H Upadhyay
Sent
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
Anand thanks for the help but the condition is if it should not consider the
time after normal working hours that is 8am to 8pm
Regards
Sathish Jalendran
-Original Message-
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of anandydr
Sent: 22 November 2008 04:46
=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 dat
35 matches
Mail list logo
