Dear Experts:
See the attached spreadsheet.
I have a cell which is a percentage of a final number; and the final number
is calculated as the maximum of two sums, while the percentage cell is an
item/element of one of the sums.
Is it possible to reconcile this by using an algebraic formula for
Sender: excel-macros@googlegroups.com
Date: Sat, 15 Sep 2012 22:38:16 +0530
To: excel-macros@googlegroups.com
ReplyTo: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Excel Formula challenge
Nicely done
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros
...@gmail.com
*From:* in.vaib...@gmail.com
*Sent:* Saturday, September 15, 2012 12:19 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Re: Excel Formula challenge
It workz for the given case but if more txt is der den formula wil run for
milez :p
I'm figuring formula dat
Hi
PFA
Cheerz..
Rgds//Vabs
On Wednesday, August 8, 2012 9:33:25 PM UTC+5:30, Rajan_Verma wrote:
* *
*Hi group,*
* *
*Hope you will post an excellent solution here :*
*Let suppose you have a string like below :*
*A|A|A|B|B|C|A|B|C|D*
*As you can see the characters are being
Nicely done
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vabz
Sent: 15 September 2012 10:04
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Excel Formula challenge
Hi
PFA
-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Excel Formula challenge
Nicely done
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vabz
Sent: 15 September
: Excel Formula challenge
Any Reply???
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 08 August 2012 9:33
To: excel-macros@googlegroups.com
Subject: Excel Formula challenge
Hi group,
Hope you will post an excellent
@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ FW: Excel Formula challenge
** **
Dear Rajan,
** **
We can use it..
** **
Function NTest(rng As String)
Dim ch As String
Dim i As Integer
Dim j As Integer
With Application.WorksheetFunction
rng
.*
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
*Sent:* 09 August 2012 8:30
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ FW: Excel Formula challenge
Subject: Re: $$Excel-Macros$$ FW: Excel Formula challenge
This solution is provided on below link, incase of Excel Formula
http://www.mrexcel.com/forum/showthread.php?652427
On Fri, Aug 10, 2012 at 9:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
Dear Rajan,
You have all the entries
:* 09 August 2012 8:30
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ FW: Excel Formula challenge
Dear Rajan,
We can use it..
Function NTest(rng As String)
Dim ch As String
Dim i As Integer
Dim j As Integer
challenge
Any Reply???
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 08 August 2012 9:33
To: excel-macros@googlegroups.com
Subject: Excel Formula challenge
Hi group,
Hope you will post an excellent solution
you can,
As long as ever you can.” - John Wesley
-
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Fri, August 10, 2012 2:43:23 PM
Subject: $$Excel-Macros$$ FW: Excel Formula challenge
Any Reply???
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 08 August 2012 9:33
To: excel-macros@googlegroups.com
Subject: Excel Formula challenge
Hi group,
Hope you will post an excellent solution here :
Let
7838100659 [IM-Gtalk]*
* *
*From:* Rajan_Verma [mailto:rajanverma1...@gmail.com]
*Sent:* 08 August 2012 9:33
*To:* excel-macros@googlegroups.com
*Subject:* Excel Formula challenge
** **
* *
*Hi group,*
* *
*Hope you will post an excellent solution here :*
*Let suppose you have
@googlegroups.com
Subject: Re: $$Excel-Macros$$ FW: Excel Formula challenge
Dear Rajan,
We can use it..
Function NTest(rng As String)
Dim ch As String
Dim i As Integer
Dim j As Integer
With Application.WorksheetFunction
rng = .Trim(.Substitute(rng, |, ))
For j = 1 To Len(rng)
If VBA.Mid
Hi,
One more contest coming in below mail for all excel users and champions ...
Please go through and win it
$300 will be awarded to the most smoothly operating, cleanly developer and
user friendly application.
$150 for 2nd place and $50 for third. Winners will also receive engraved
awards
with the calendar control, you have nowhere to select
time.
Regards.
Daniel
*De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
*De la part de* Deepak Rawat
*Envoyé :* jeudi 23 décembre 2010 12:24
*À :* excel-macros@googlegroups.com
*Objet :* Re: $$Excel-Macros
Hi
i didnt mean to hurt anybody!!
Thanx Daniel for ur friendly support!!!
One thing i also want in this file that the calender should take current
date time by itself.
Thanx
Deepak
On Fri, Dec 17, 2010 at 10:27 AM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi i have posted this problem two
Hi i have posted this problem two times but got no reply
Is it a challenge!!!
Dear All
I am designing a user form but new to this, so i need help on prgramming.
The logic i am mentioning here as under:
Threre are 2 comboBoxes, one calender, and amount file.
What i want
1. Which date i would
@googlegroups.com
Objet : $$Excel-Macros$$ Is it a Challenge!
Hi i have posted this problem two times but got no reply
Is it a challenge!!!
Dear All
I am designing a user form but new to this, so i need help on prgramming.
The logic i am mentioning here as under:
Threre are 2 comboBoxes, one
: excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Is it a Challenge!
Hi i have posted this problem two times but got no reply
Is it a challenge!!!
Dear All
I am designing a user form but new to this, so i need help on prgramming.
The logic i am mentioning here as under
As you are aware that lots of emails cannot be tracked and replied soon it
doesnot mean that is a challenge..!
On Fri, Dec 17, 2010 at 10:27 AM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi i have posted this problem two times but got no reply
Is it a challenge!!!
Dear All
I am designing
Kindly attach sample file.
On Wed, Sep 1, 2010 at 12:12 AM, Kurt heislerk...@gmail.com wrote:
Can't seem to get this working.
If A1 is a calculated error (e.g., #NULL) OR If A1 = --- , make
B1 = NA
Otherwise: If A1 Y1, make B1 = !, otherwise make B1 = (i.e.,
blank).
This is what I
Posted it to the file list. It's called ISERROR Example.xls.
On Sep 1, 1:00 am, C.G.Kumar kumar.bemlmum...@gmail.com wrote:
Kindly attach sample file.
On Wed, Sep 1, 2010 at 12:12 AM, Kurt heislerk...@gmail.com wrote:
Can't seem to get this working.
If A1 is a calculated error (e.g.,
25 matches
Mail list logo