Hi Priya,
Please find attachment.
Let me know if you need anything else.
Thanks & Regrds,
Kaushik Savla
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
Dear all
I use the attached excel sheet to calculate the profit/loss in the trading
of individual stocks. The formula works fine in normal cases. But whenever
there is some bonus/stock split etc. it fails. Can someone help me to derive
a formula that will suit all cases?
--
Regards
Yahya
--
* Priya Jose
> *Sender: * excel-macros@googlegroups.com
> *Date: *Sun, 17 Oct 2010 15:52:52 +0300
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Formula required
>
> Dear All,
>
> Please find attach the file I need solution, requesting
Subject: $$Excel-Macros$$ Formula required
Dear All,
Please find attach the file I need solution, requesting you guys to be kind
enough to share your knowledge.
If possible i think please provide using the Index match or offset
Waiting in anticipation..!!
Regards
Priya
: $$Excel-Macros$$ Formula required
Dear All,
Please find attach the file I need solution, requesting you guys to be kind
enough to share your knowledge.
If possible i think please provide using the Index match or offset
Waiting in anticipation..!!
Regards
Priya
Asst. HR
Dear All,
Please find attach the file I need solution, requesting you guys to be kind
enough to share your knowledge.
If possible i think please provide using the Index match or offset
Waiting in anticipation..!!
Regards
Priya
Asst. HR
--
-
Thanks Sir, problem solved ...though the array seems complex for me to
understand...
Salute to Excel-Macros
With Best Regards.
On 9/15/10, ashish koul wrote:
>
> check the attachment see if it helps
>
> On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
>
>> Dear Sirs,
>>
>> I w
Hi,
Please see the attached for a possible solution.
Regards - Dave.
On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
Dear Sirs,
I want to capture data which employees are on leave as on date and
since when ?
Formula please…..
(Format enclosed)
NAME01-Sep 02-Sep 03-Sep 04-Sep 0
check the attachment see if it helps
On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
> Dear Sirs,
>
> I want to capture data which employees are on leave as on date and
> since when ?
> Formula please…..
>
> (Format enclosed)
>
> NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Se
Dear Sir,
Problem partially solved. Result Cell should be blank if an employee is
already joined and now working.I have to find out continuous leave of an
employee from a particular date till today.Also highlight with colour thro.
conditional formating.
Enclosed file ...
Regards.
On 9/14/10, as
can you please attach excel file
On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
> Dear Sirs,
>
> I want to capture data which employees are on leave as on date and
> since when ?
> Formula please…..
>
> (Format enclosed)
>
> NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep Leave
Dear Sirs,
I want to capture data which employees are on leave as on date and
since when ?
Formula please…..
(Format enclosed)
NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep Leave Since
A AB AB AB AB AB AB AB 01-Sep
B pr pr
hours
does that help?
Paul
____
From: JohnA
To: MS EXCEL AND VBA MACROS
Sent: Thu, September 2, 2010 2:11:03 PM
Subject: $$Excel-Macros$$ Formula for Military Time Calculations
I need to determine time increments from postings in Excel in the 24
hour mode
Hi John,
Could you send a sample set of data.
Regards,
Andy
On Thu, Sep 2, 2010 at 11:41 PM, JohnA wrote:
> I need to determine time increments from postings in Excel in the 24
> hour mode (commonly called military time).
>
> I can't come up with a formula to give me decimal hours from militar
I need to determine time increments from postings in Excel in the 24
hour mode (commonly called military time).
I can't come up with a formula to give me decimal hours from military
time subtractions.
Help please!
JohnA
--
---
Dear Jay,
Problem is solved. See the attachment.
On Wed, Aug 25, 2010 at 2:26 PM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> -
Jay
Try putting the following formula in cell C3:
=LEFT(B3,FIND(" ",B3,1))
Norman
On Wed, Aug 25, 2010 at 4:56 AM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> -
Dear Lucky,
Please find attachement with solution.
Thanks,
Noorain Ansari
On Wed, Aug 25, 2010 at 2:26 PM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> ---
Hi,
Need help in formula...
I just need the only the first name to be extracted without space or gap...
Regards,
Jay S
8108932708
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Dear Andy,
Thank u
On Fri, Jun 4, 2010 at 3:55 PM, Aindril De wrote:
> Hi Venkat,
>
> This can be achieved using array formulas in Excel.
> Suggest you to look into the discussion in the attached link that should
> resolve your issue:
> http://www.mrexcel.com/forum/showthread.php?t=312142
>
Hi Venkat,
This can be achieved using array formulas in Excel.
Suggest you to look into the discussion in the attached link that should
resolve your issue:
http://www.mrexcel.com/forum/showthread.php?t=312142
Regards,
Andy
On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c wrote:
> Dear Group,
>
>
Dear Group,
Can i have UNIQUEIFS Function its some thing like SUMIFS
Best Regards,
*
Venkat
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/e
Thanks for your reply but can you solve my query with formulas. Because I
don't know any thing about Macros how to use it or where to insert macro
code. Your reply will highly appriaciated.
Regards,
Aamir Shahzad
On Sun, May 30, 2010 at 10:20 PM, Mahesh parab wrote:
> Hi Aamir
> i herewith att
Dear all,
Vlookup pick only one value from desired sheet but I want to pick multiple
values. Is there any formula to pick values & automatically insert rows
without any micro because I don't have idea. Sheet attached.
Regards,
Aamir Shahzad
--
--
start writing your own macro library
On May 3, 3:17 pm, D Kumar wrote:
> Hi All,
>
> I am not a perfect in excel but i have a little bit knowledge of some
> formulas, is anyone in group can help me to learn more about excel with
> ready reference.
>
> Regards
> Dheeraj S Chauhan
>
> ***All thing
Thanks Shayam for the link to the great site... But does anyone knows
any site from where I can download the details of these functions.. I
want to read them at my leasure time at home as it is impossible to go
through them during the office hours..
Thanks
ZAC
On Tue, May 4,
Hello Dear,
Try the following link
http://www.cpearson.com/excel/topic.aspx
There is a details of all functions and formulas.
On Mon, May 3, 2010 at 8:47 PM, D Kumar wrote:
> Hi All,
>
> I am not a perfect in excel but i have a little bit knowledge of some
> formulas, is anyone in group
Hi All,
I am not a perfect in excel but i have a little bit knowledge of some
formulas, is anyone in group can help me to learn more about excel with
ready reference.
Regards
Dheeraj S Chauhan
***All things are difficult before they are esay***
--
---
and returns
> the
> > REMAINDER.
> >
> > So, you could use: =if(mod(A2,6)=0,(B2*C2)+B2,B2)
> >
> > although I'm not sure if the rest of your formula is correct...
> > But this will at least get your first question answered...
> > Paul
> > _
eturns the
> REMAINDER.
>
> So, you could use: =if(mod(A2,6)=0,(B2*C2)+B2,B2)
>
> although I'm not sure if the rest of your formula is correct...
> But this will at least get your first question answered...
> Paul
> ____
> From: Sastry
>
'm not sure if the rest of your formula is correct...
But this will at least get your first question answered...
Paul
From: Sastry
To: MS EXCEL AND VBA MACROS
Sent: Fri, February 19, 2010 12:44:25 PM
Subject: $$Excel-Macros$$ formula for showing multiple o
Hi Group,
I am writing a simple formula for a compounding interest. Let me
quickly take you through the example.
Monthly Investment - Rs.2000
Yearly Interest - 10% (compounded twice a year) i.e., 5% every 6th
month
Tenor - 1 year
Month Investment Interest Cls Bal
(Col A) (ColB) (Col
Dave.
> Date: Wed, 10 Feb 2010 15:46:55 -0800
> Subject: $$Excel-Macros$$ Formula Array to VBA Code
> From: mark.ku...@gmail.com
> To: excel-macros@googlegroups.com
>
> I have a search formula that resides in a cell. The idea is if
> something is found return a 1 if not return
I have a search formula that resides in a cell. The idea is if
something is found return a 1 if not return 0 based on conditional
formatting, a color is assigned. This array seeking the max value for
a true instance.
Additional piece of info, the search is used a column value, many
contain 25 st
Hi All,
Thanks for all your inputs.
Now I am able to consolidate my data very easily
Regards,
Suresh
On Sat, Feb 6, 2010 at 3:45 PM, Dilip Pandey wrote:
> Dear Suresh,
>
> Attached is the solved file as per your requirements.
> Let me know if this solves your purpose.
>
> Best Regards,
> --
>
Dear Suresh,
Attached is the solved file as per your requirements.
Let me know if this solves your purpose.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/5/10, suresh k wrote:
>
> Hi S
Dear Suresh,
Please find the solution
Sanjoy
On Fri, Feb 5, 2010 at 5:11 PM, Sivakumar E.S wrote:
> Hi
>
> Find attached solution for your problem.
>
> Regards
> Sivakumar ES
>
>
>
>
>
> On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
>
>> Hi,
>>
>> I have the very large data to consolidat
Hi
Find attached solution for your problem.
Regards
Sivakumar ES
On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
> Hi,
>
> I have the very large data to consolidate. To consolidate I need a formula.
>
> Below is the example.
>
> My Input data will be
>
> *Input*
> Hari
> Yes
> Hari
Hi Suresh,
Please use pivot Table.
On Fri, Feb 5, 2010 at 4:09 PM, Sanjoy Nath wrote:
> Please give the file attached
> I will make it for you.
>
>
>
> On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
>
>> Hi,
>>
>> I have the very large data to consolidate. To consolidate I need a
>> formula.
Hi Sanjay,
Pls find sample file and let me know if you could help me on this.
On Fri, Feb 5, 2010 at 4:09 PM, Sanjoy Nath wrote:
> Please give the file attached
> I will make it for you.
>
>
>
> On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
>
>> Hi,
>>
>> I have the very large data to conso
Please give the file attached
I will make it for you.
On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
> Hi,
>
> I have the very large data to consolidate. To consolidate I need a formula.
>
> Below is the example.
>
> My Input data will be
>
> *Input*
> Hari
> Yes
> Hari
> No
> Hari
>
Hi,
I have the very large data to consolidate. To consolidate I need a formula.
Below is the example.
My Input data will be
*Input*
Hari
Yes
Hari
No
Hari
Yes
Hari
No
Hari
No
Girish
Yes
Girish
No
Girish
Yes
Girish
Yes
Girish
Yes
Girish
No
Girish
No
And output data s
Hi All,
I have the following code which is supposed to select the activecell
and then add a sumproduct formula to the value in the cell already. My
problem is that the criteria
for the sumproduct formula is taken from a combobox in a user form.
ActiveCell.Select
With ActiveCell
.Formula = .Va
Hi Niraj,
when i looke closely, i found that you have a "Space" after every value.. i
deleted the space and the formula worked
check attachment
Regards, Madhu
On Wed, Nov 25, 2009 at 7:05 PM, Niraj Kothari wrote:
> Dear ,
>
> I am trying to multiply the values in this attached excel sheet but
xcel-macros@googlegroups.com
> *Sent:* Wed, November 25, 2009 8:35:27 AM
> *Subject:* $$Excel-Macros$$ Formula Calculation Problem
>
>
> Dear ,
>
> I am trying to multiply the values in this attached excel sheet but it is
> not accepting. It says some formula or text problem. The i ind
e more than 1 of such data which has to be
multiplied
awaiting your reply
Thanks in advance
Regards
Niraj Kothari
From: Niraj Kothari
To: excel-macros@googlegroups.com
Sent: Wed, November 25, 2009 8:35:27 AM
Subject: $$Excel-Macros$$ Formula
Dear ,
I am trying to multiply the values in this attached excel sheet but it is
not accepting. It says some formula or text problem. The i individually
clicked each cell and deleted a space after each value and again tried
multiplying then the formula worked.
Is there any direct formula or macro
Hi All,
I need some help.
I have a cell where there is Account Number and Cust Name and a codification
before the Acct Num.
*PlanGroup* P#C1299 J L Morison (India) Ltd
I would like a formula that is taking only numbers from this cell.
Could you help with this ?
Thanks
--
Regards
Nou
Hi All,
Can any one tell me the formula to get the value as in Required answer as
against Original Value.
*Original Value*
*Required answer*
125756.95-
-125756.95
75845.25-
-75845.25
123.38-
-123.38
10.15-
-10.15
158946-
-158946.00
856456.25-
-856456.25
Regards- Putta Madaiah-
Anyone know how to toggle to a cell in a formula?
For example
if a cell contains the formula "=A4*B7", that this toggle will take
you to cell A4.
i was hoping for a quicker way to do this than Formula Auditing.
Thanks
--~--~-~--~~~---~--~~
Dear Friends,
I need a formula for my work.
There will be 2 Excel sheets.
In First Sheet there will be 2 Columns
In First column there will be code and in 2nd column there will be value and
'n' number of rows will be there. And the code may be repeated at several
times in different rows.
And i
-
From: Habeeb Mohammed
To: excel-macros@googlegroups.com
Sent: Friday, May 15, 2009 9:34 AM
Subject: $$Excel-Macros$$ formula in macros
Hi Guys,
I currently written a code were in total will be populated by adding various
sub totals. But I am not able to put in the formula
Hi Guys,
I currently written a code were in total will be populated by adding various
sub totals. But I am not able to put in the formula for adding for future
reference. I am not able to think a logic for that.
I have explained my requirement in the attachement.
Please help me
Can you help me please? I have a bit of a situation and I need some
fresh eyes and brain power. I am trying to set up a spreadsheet for my
dad in excel and I have run into a formula snag. This is the last
formula I need to complete this worksheet and I need to get it right.
My brain hurts from tr
601 - 654 of 654 matches
Mail list logo