Hello Kartik,
Thanks for the information :)
Regards,
Chandru
On Mon, Nov 25, 2013 at 5:54 PM, Kartik Dale 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 to 0.
>
> * mea
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.Whe
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 wrote:
> Hi all,
>
> I'm having a problem with importing CSV files into Excel. My CSVs contain
> dates forma
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
2
Dear Experts,
I want to make one VBA for handling the stock of shares with price in FIFO
method so kindly help me on the this matter.
And If you have any VBA for maintaining the stock of share the please
provide me.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=
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. T
Sir, Can you tell me how to check and how modified
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 7:02 PM, "Papnay, Ashish" 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 Papnay*
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
>
> http://excelautomate.blogspot.in/2013/11/what-i
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
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,
>
Any help,dear?
On Mon, Nov 25, 2013 at 1:39 PM, amar takale 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 wrote:
>
>> U wants download pdf file form outlook account or you have saved thse
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" wrote:
> yeah, but can u share the snap shot..
>
> coz ur example sheet formula is working fine on my system
>
>
>
>
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 wrote:
> Same error which is in my first attachmentsir
>
> Regard,
> Prafull Jadhav.
> 9920553518
>
Same error which is in my first attachmentsir
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 1:53 PM, "xlstime" wrote:
> please share the snap shot
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Mon, Nov 25, 2013 at 1:50 PM, Prafull Jadhav
> wrote:
>
>> Dear Sir,
>>
>> Sa
please share the snap shot
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:50 PM, Prafull Jadhav wrote:
> Dear Sir,
>
> Same is working on other PC
>
> Regards,
> Prafull Jadhav
> 9920553518
>
>
> On Mon, Nov 25, 2013 at 1:49 PM, Prafull Jadhav
> wrote:
>
>> Dear Sir,
>> I
Dear Sir,
Same is working on other PC
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:49 PM, Prafull Jadhav wrote:
> 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 wro
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 wrote:
> you can try with "--"
>
> formula like =--A3
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Mon, Nov 25, 2013 at 1:19 PM, Praful
you can try with "--"
formula like =--A3
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:19 PM, Prafull Jadhav wrote:
> Dear All ,
>
> Very Good Afternoon,
>
> Please find the attachment where i have put value formula for date column
> ..but it is not working ..Same formu
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 wrote:
> 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
>
>
>
> *Fro
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 Excel
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: excel-macr
21 matches
Mail list logo