Mine Fav Formula this week is
=COUNTIF(A$3:A3,A3)
It resolved my headache...Give ranking n order number for repetitive
values
Love tht one
--
--
Some important links for excel users:
1. Follow us on TWITTER for ti
NSARI
Sent: Friday, January 14, 2011 12:38 PM
To: excel-macros@googlegroups.com
Cc: ashish koul
Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula
Dear Ashish,
I am unable to find data through Vlookup+indirect when sheet name is Date
wise like 14-Jan,15-Jan,16-Ja
P for you to have a look at.
Regards - Dave
Date: Fri, 14 Jan 2011 01:53:41 -0800
Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Hi Dave,
How can solve it. Please give ur valauble suggestion..
Thank
> Regards - Dave.
>
> --
> Date: Thu, 13 Jan 2011 23:08:24 -0800
>
> Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula
> From: noorain.ans...@gmail.com
>
> To: excel-macros@googlegroups.com
> CC: koul.ash...@gmail.co
Hi,
The problem is not the sheet names, but the indirect refering to a date, which
is really just a date code, not a date as displayed.
Regards - Dave.
Date: Thu, 13 Jan 2011 23:08:24 -0800
Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula
From: noorain.ans
Dear Ashish,
I am unable to find data through Vlookup+indirect when sheet name is Date
wise like 14-Jan,15-Jan,16-Jan.
Please see attached sheet..
--
Thanks & regards,
Noorain Ansari
On Thu, Jan 13, 2011 at 9:49 PM, ashish koul wrote:
> hi
> 1 case sensitive lookup using index and match
One of the function which I do like is "TRANSPOSE" function.
- This function copies data from a range, and places in it in a new range,
turning it so that the data originally in columns is now in rows, and the
data originally in rows is in columns.
- The transpose range must be the same size as t
hi
1 case sensitive lookup using index and match
2 vlookup & indirect function
Check the attachment. Given you the situations where I used them in the past
On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . wrote:
> Hi All,
>
> I suggest all of you don't say this function I like and then thi
Hi All,
I suggest all of you don't say this function I like and then this one like
that. Just sharing the function name won't help others to gain some
knowledge. All the functions which is available in excel is having the same
set of qualities unless it is used in perfect combination.
So give b
Hi All,
from my side.
=INT()
On Jan 13, 2011 9:04pm, kiran Kancharla wrote:
Hi All,
from my side I am adding 2 formulas.
1.Index
2.Match
One of the best functions..
Please have a look on the Attachment..
Thanks & Regards,
Kiran
On Thu, Jan 13, 2011 at
Dear members,
We all come to know about many functions & their best uses.
Please keep sharing. Thanks.
Best Regards,
Ayush Jain
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks an
>> favourite formula, not favourite function. Please clarify.
>> Regards - Dave.
>>
>> --
>> From: rohan.j...@gmail.com
>> Date: Wed, 12 Jan 2011 16:01:19 +0530
>>
>> Subject: Re: $$Excel-Macros$$ Formula of the week - shar
e clarify.
> Regards - Dave.
>
> --
> From: rohan.j...@gmail.com
> Date: Wed, 12 Jan 2011 16:01:19 +0530
>
> Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula
> To: excel-macros@googlegroups.com
> CC: jainayus...@gmail.com
&g
PM
Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi Ayush,
One of my Best formula is OFFSET.
Reason:- It can be used in getting the desired value (located) anywhere in the
spreadhseet, the desired Sum, Average etc. It is also used
for creating dynamics ranges
Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi Ayush Ji,
My formulas are
CHOOSE - we can rank the candidates with choose & code combination
CHOOSE(CODE(B1)-64,"Excellent","Best","Poor"), if B1has the value A, B, or
C.
Hi Ayush,
There seems to be some confusion. I thought the question related to our
favourite formula, not favourite function. Please clarify.
Regards - Dave.
From: rohan.j...@gmail.com
Date: Wed, 12 Jan 2011 16:01:19 +0530
Subject: Re: $$Excel-Macros$$ Formula of the week - share your best
Hi Ayush Ji,
My formulas are
*CHOOSE -* we can rank the candidates with choose & code combination
CHOOSE(CODE(B1)-64,"Excellent","Best","Poor"), if B1has the value A, B, or
C.
*CELL("FILENAME",A1) - *we can get instant result of the path of the current
file with sheet name.
*REPT - *This one g
Hi Ayush,
One of my *Best* formula is *OFFSET*.
Reason:- It can be used in getting the desired value (located) anywhere in
the spreadhseet, the desired Sum, Average etc. It is also used
for creating dynamics ranges - which further can be used in formulas /
conditional formatting.
Best Regards,
Hi Group
My Best formula for the week is:
XNPV() - We can use it to calculate the net present value of a cash flow.
Thanks & Regards
Sumit Kumar
On Wed, Jan 12, 2011 at 11:36 AM, NOORAIN ANSARI
wrote:
> Hi Group,
>
> My Best Formula for this week is.
>
> SUMPRODUCT()-We can use it instead of
Hi Group,
My Best Formula for this week is.
SUMPRODUCT()-We can use it instead of *Sumif*,*Countif*,*Sumifs* and *Countifs
*in 2003 or 2007.
--
Thanks & regards,
Noorain Ansari
On Tue, Jan 11, 2011 at 9:09 AM, Kenil Gala wrote:
> Hi group,
> My formulas for the week is
>
> 1. normdist = to
Hi group,
My formulas for the week is
1. normdist = to find the normal distribution of random numbers.
2. FV = To find the future value of the cash flows.
3. stdev = to find the standard deviation of the distribution.
Thanks & Regards,
Kenil Gala
From: Ayush
21 matches
Mail list logo
