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,
>From My Side,
Best Formula is Match()
Regards,
Rajesh. Nair
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Li
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,
---
>> *From:* Ayush
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Tue, January 11, 2011 10:04:30 PM
>> *Subject:* $$Excel-Macros$$ Formula of the week - share your best formula
>>
>> Dear Group,
>>
>> Let's discuss excel formula this week. Each of
Ayush
> *To:* excel-macros@googlegroups.com
> *Sent:* Tue, January 11, 2011 10:04:30 PM
> *Subject:* $$Excel-Macros$$ Formula of the week - share your best formula
>
> Dear Group,
>
> Let's discuss excel formula this week. Each of us use many formulas in our
> excel reports
yush
To: excel-macros@googlegroups.com
Sent: Tue, January 11, 2011 10:04:30 PM
Subject: $$Excel-Macros$$ Formula of the week - share your best formula
Dear Group,
Let's discuss excel formula this week. Each of us use many formulas in our
excel
reports , dashboard metrics etc.
Please share
Dear Group,
Let's discuss excel formula this week. Each of us use many formulas in our
excel reports , dashboard metrics etc.
Please share your best formula and the reason for being the best.
If all of you will share atleast one formula, Then I hope to cover all
formulas in excel. :D
My one of
23 matches
Mail list logo