Dear Experts,
Please help me to formulate a formula where the Periodicity and the Start
Date are taken into consideration to make the Cashflows. The formula should
be automatically adjusting the Cashflows based on the above two assumptions
selected. There should be no Cashflows before the start m
Thank you very much to one and all.. for giving response... it worked ...
it saves me a lot of time ... for a mammoth data of having 65000 records...
Raghu Nandan R
On Mon, Jan 9, 2012 at 9:07 PM, Rajan_Verma wrote:
> Put this in C2 and fill down.
>
> ** **
>
> =IF(A2=A3,"",COUNTIF($A$2:$A$17
Hi All,
I would like to take your help in finding the special characters in a cell.
Here is the output I'm looking for.
B1 = XYZ_Apr'11
Then I should get a message box saying it has a special character (').
Similarly for all other special characters.
Here the special characters position is no
Hello, i have this code, i apologize as it is messy. But i am trying
to loop through two columns, i want the loop to read the column on the
right and for eah item on the right i want the second loop to search
through the "database" i have created and create a new tab for it.
Here is the sheet, any
Hi,
In K14 and copied down,
=SUM(IF(FREQUENCY(IF($B$2:$B$13=H14,IF($C$2:$C$13<>"",MATCH($B$2:$B$13&$C$2:$C$13,$B$2:$B$13&$C$2:$C$13,0))),ROW($B$2:$B$13)-ROW($B$2)+1),1))
It's an array formula. Confirmed with CTRL + SHIFT + ENTER.
Kris
--
FORUM RULES (986+ members already BANNED for violation)
Hi Rajan,
This formula is not capturing correct counts.
regards
lokesh.M
On Mon, Jan 9, 2012 at 8:33 PM, Rajan_Verma wrote:
> Use this in F4
>
> Range = J2:J21 in DeleteReport sheet
>
> ** **
>
> =SUMPRODUCT(--(Sheet2!G2:G65536='consolidated
> report'!B4),(Sheet2!D2:D65536))+IFERROR(VLO
DearRajan,
Please see attached file... I want unique count of cabs visited with the help
of Pivot..
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: 09 January 2012 20:12
To: excel-macros@googlegroups.com
Subject: RE:
If you are using Excel 2003 or lesser, use
=SUMPRODUCT('OWN MACHINERY'!$F$3:$F$467,--('OWN
MACHINERY'!$B$3:$B$467=Sheet1!$B3),--('OWN
MACHINERY'!$G$3:$G$467=Sheet1!C$2))
Regards,
Sam Mathai Chacko
On Mon, Jan 9, 2012 at 11:10 PM, Rajan_Verma wrote:
> You can use sumifs:
> =SUMIFS('OWN MACHINER
You can use sumifs:
=SUMIFS('OWN MACHINERY'!$F:$F,'OWN MACHINERY'!$B:$B,Sheet1!$B8,'OWN
MACHINERY'!$G:$G,Sheet1!C$2)
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kumar Punnam
Sent: Jan/Mon/2012 06:45
To: excel-macros@googlegroup
With these solution.. check the function name if you are not typing
correctly..
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Eddie
Sent: Jan/Mon/2012 06:43
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ UDF
I'm typin
Put this in C2 and fill down.
=IF(A2=A3,"",COUNTIF($A$2:$A$17,A2))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of raghunandan rallapalli
Sent: Jan/Mon/2012 01:59
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ count a cell having same dat
If they are working with Whole Excel may be Those macro are saved in
Personal Workbook or an add-ins .. GOTO VBE and delete them..
Regards
Rajan
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of kip
Sent: Jan/Mon/2012 12:19
To: MS
Use this in F4
Range = J2:J21 in DeleteReport sheet
=SUMPRODUCT(--(Sheet2!G2:G65536='consolidated
report'!B4),(Sheet2!D2:D65536))+IFERROR(VLOOKUP(C4,Range,2,0),0)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Jan/Sun/2012 07:52
To
Hi Amit
See the attached file..
Please Revert if it not desired
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: Jan/Sun/2012 02:15
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Unique count in Pivot table
HI,
Try this :
Please revert with Calculation Output,, I did not covert last two point in
this :
Sub Test()
Dim wksSheetAs Worksheet
Set wksSheet = Sheet1
With wksSheet
.Rows.AutoFit
.Columns.AutoFit
.Cells.MergeCells = False
.Ro
Hi,
We are not getting you query. Please explain with attached workbook.
Thanks
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of sudhir kumar
Sent: Jan/Sat/2012 11:25
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Piovet Table
HI Lokesh
is your query resolved?
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Jan/Sat/2012 07:01
To: excel-macros@googlegroups.com
Subject: Re: Fwd: $$Excel-Macros$$ User login and logout time
Thank you very much raja
This is page Layout View of worksheet..
You can goto View and select PageLayout..
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: Jan/Sat/2012 04:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Multiple worksh
I'm typing the following into the detination cell
"=decile_rank(E2:E60,I2)"
On Jan 9, 1:06 pm, "dguillett1" wrote:
> Without looking too close or testing:
> 1. is it in a REGULAR module. Will NOT work in sheet module
> 2. DataRange is asking for a range such as a1:b10
> 3. RefCell is asking for
Without looking too close or testing:
1. is it in a REGULAR module. Will NOT work in sheet module
2. DataRange is asking for a range such as a1:b10
3. RefCell is asking for a cell such as b12
Hope this helps
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From:
How do I get this UDF to function correctly? I keep getting #name? in
the destination cell.
Thanks in advance.
Ed.
' This User Defined Function can be called to calculate which Decile a
single cell
' falls within a larger range of cells
Public Function DECILE_RANK(DataRange, RefCell)
'DECILE_R
Dear Sunil,
missing attachment
On Mon, Jan 9, 2012 at 4:33 PM, sunil bn wrote:
> Hi Expert,
>
> I have attached file kindly help me to solve this.
>
> --
>
> *Regards*
> **Sunil B.N
> ***9035858585
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate
Dear Raghunandan,
Try it..
=IF(SUMPRODUCT(--($A$2:$A$17=A2))=SUMPRODUCT(--($A$2:A2=A2)),SUMPRODUCT(--($A$2:$A$17=A2)),"")
or
=IF(COUNTIF($A$2:$A$17,A2)=COUNTIF($A$2:A2,A2),COUNTIF($A$2:$A$17,A2),"")
See attached sheet...
--
Thanks & regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com
Hi Expert,
I have attached file kindly help me to solve this.
--
*Regards*
**Sunil B.N
***9035858585
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
please find attached solution
Date: Mon, 9 Jan 2012 13:58:44 +0530
Subject: $$Excel-Macros$$ count a cell having same data it appeared in number
of times
From: raghunandan.rallapa...@gmail.com
To: excel-macros@googlegroups.com
Sir, kindly find the attachment and help me to get count a cell hav
Hi
In B2 and copied down,
=IF(COUNTIF($A$2:A2,A2)=1,COUNTIF($A$2:$A$17,A2),"")
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wi
Sir,
kindly find the attachment and help me to get count a cell having same data
it appeared in number of times..i need a formula for this..
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
27 matches
Mail list logo
