U wants download pdf file form outlook account or you have saved thses files
in a folder and then need to open and save in a specific folder
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Monday, November 25, 2013 1:25 PM
To:
Hello,
What is the difference between ),-- and *-- in sumproduct function.
=SUMPRODUCT(--(Sheet1!$AK$2:$AK$5=P$7)*--(Sheet1!$J$2:$J$5=$B$7))
=SUMPRODUCT(--(Sheet1!$AK$2:$AK$5=P$7),(--(Sheet1!$J$2:$J$5=$B$7)))
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Dear ravinder
Extactly,perfect which I want,you say right but how can do it
regards
Amar
On Mon, Nov 25, 2013 at 1:30 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
U wants download pdf file form outlook account or you have saved thses
files in a folder and then need to open and save in a
you can try with --
formula like =--A3
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:19 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear All ,
Very Good Afternoon,
Please find the attachment where i have put value formula for date column
..but it is not
Dear Sir,
It is also not working ...
Value error is there .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:43 PM, xlstime xlst...@gmail.com wrote:
you can try with --
formula like =--A3
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:19 PM,
Dear Sir,
Same is working on other PC
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:49 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear Sir,
It is also not working ...
Value error is there .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:43
please share the snap shot
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:50 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear Sir,
Same is working on other PC
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:49 PM, Prafull Jadhav
Same error which is in my first attachmentsir
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 1:53 PM, xlstime xlst...@gmail.com wrote:
please share the snap shot
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:50 PM, Prafull Jadhav
yeah, but can u share the snap shot..
coz ur example sheet formula is working fine on my system
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:56 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Same error which is in my first attachmentsir
Regard,
Prafull
Sir...same formula is working in other all friends pc...Only I m facing
same problem
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 2:18 PM, xlstime xlst...@gmail.com wrote:
yeah, but can u share the snap shot..
coz ur example sheet formula is working fine on my system
Any help,dear?
On Mon, Nov 25, 2013 at 1:39 PM, amar takale amartak...@gmail.com wrote:
Dear ravinder
Extactly,perfect which I want,you say right but how can do it
regards
Amar
On Mon, Nov 25, 2013 at 1:30 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
U wants download pdf file form
Hi Chandru,
if you use -- in front of the formula, it will convert Boolean values to
1's 0's. For true it will convert to 1 for false it will convert to 0.
* means multiply
Regards,
Cartik
On Mon, Nov 25, 2013 at 1:34 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
What
On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote:
Hi webies,
I just started blogging, please check the excel automation blog
www.excelautomate.blogspot.in...
please share your comments and more information about excel macros...
With Thanks,
Anoop.V
--
Are you
http://excelautomate.blogspot.in/2013/11/10-quick-time-saving-excel-shortcuts.html
check for excel short cuts
On Saturday, 23 November 2013 14:42:18 UTC+5:30, anoop kumar wrote:
Introduction to VBA programming...guys please check it out
Sir, Can you tell me how to check and how modified
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 7:02 PM, Papnay, Ashish apap...@metlife.com wrote:
Hi Prafull,
What is the format of date in your system.
Like in my system the date formate is MM/DD/YY.
*Regards*
*Ashish
Hi all,
I'm having a problem with importing CSV files into Excel. My CSVs contain
dates formatted Canadian style, dd/mm/. However, when some users open
these files, Excel interprets the date as mm/dd/. (So the text string
01/09/2013, which should mean Sep 1 2013, becomes Jan 9 2013.
Hi All,
Good Morning,
Please find the updated Hotlist.
*Name*
*Skill Set*
*Yrs of Exp*
*Location*
*Relocation*
*Availability*
*Prashant*
SAP BASIS
10+ Years
WA
Open
Immediate
*Srikanth*
SAP BASIS
08+ Years
PA
Open
1 Weeks’ Notice
*Ashfaq*
Siebel Admin
14+ Years
CA
Open
try to change the current location to Canada as well and also please check
the date in additional settings as well in Region and Language
On Tue, Nov 26, 2013 at 12:26 AM, Trevor Barrie tbar...@gmail.com wrote:
Hi all,
I'm having a problem with importing CSV files into Excel. My CSVs
I need to find liked number patterns within my spreadsheet that has
around 500,000 rows. The data that I have entered looks like this:
You will notice it has game numbers (column 1) and a location (Column 6)
along with four numbers (column 2-3-4-5) that we will call counter
numbers.When
Hello Kartik,
Thanks for the information :)
Regards,
Chandru
On Mon, Nov 25, 2013 at 5:54 PM, Kartik Dale kartik.1...@gmail.com wrote:
Hi Chandru,
if you use -- in front of the formula, it will convert Boolean values to
1's 0's. For true it will convert to 1 for false it will convert
20 matches
Mail list logo
