Dear Amir,
IFERROR will not work in excel 2003. Try this one
=IF(ISNA(IF(ISNA(VLOOKUP(B6,$E$3:$F$3,2,0)),VLOOKUP(B6,$H$3:$I$3,2,0),VLOOKUP(B6,$E$3:$F$3,2,0))),VLOOKUP(B6,$K$3:$L$3,2,0),"")
type the above formula anywhere in worksheet. cel (b6) is taken as lookup
value.
Thanks & Regards
Thamu
Dear Jitendra,
Simply palce the cursor in any other worksheet.
for example if you want to count the number of nonblank cells in sheet1,
just place the cursor anywhere in sheet2 and =COUNTA(Sheet1!1:65536)
Thanks & Regards
Thamu
On Wed, Jan 26, 2011 at 11:43 PM, Dilip Pandey wrote:
> Hi Jit
Dear Ankur Pandey
You cannot able to keep it in a single row If you have large amount of data.
Because Excel 2003 has only 256 columns and excel 2007 has only 16384
columns.
Thanks & Regards
Thamu
On Thu, Jan 27, 2011 at 2:55 PM, ankur wrote:
> hi excel experts
> i need one help
> i need da
Hi
Find the attachment.
Thanks & Regards
Thamu
On Thu, Jan 27, 2011 at 3:04 PM, Born to Win wrote:
> Hello Expert,
>
> In Attached Sheet i am making a tracker For Attrition In first summary
> sheet i have to show Band with Colour corresponding to his Last Dated
> Status.
>
> Please help me to
Dear Dharmesh Shah,
find the attachment. it will fulfill your requirement
Regards
Thamu
On Sat, Jan 22, 2011 at 3:06 PM, Rohan Young wrote:
> Hi,
>
> i think it will more helpful to you,
>
> thanks & regards
>
> ROHAN
>
>
> On Sat, Jan 22, 2011 at 2:57 PM, Rohan Young wrote:
>
>> Hi,
>>
>>
Dear Hanumant,
check it: =IF(COUNTIF($A$1:$A$1000,"*hanumant*"
)>=1,COUNTIF($A$1:$A$1000,"*hanumant*" ) & " Times available","Not Present")
Regards
Thamu
On Tue, Jan 18, 2011 at 12:58 PM, Ankur Saraswat wrote:
> Hi Hanumant,
>
> Try it: =IF(A1:A14="a",1,"0")
>
>
>
>
> On Mon, Jan 17, 2011 at
Hi Shashank
Find the attachment.
Regards
Thamu
On Tue, Jan 18, 2011 at 12:10 PM, shashank bhosle <
catchshashankbho...@yahoo.co.in> wrote:
> HI All
>
> I want to replace some content that are in formula.
>
> Thanks and Regards
> Shashank
>
> --
>
> ---
Hi Jitendra.kumarverma,
Find the Attachment. Hope it will help you.
feel free to ask again if it is not clear.
Regard,
Thamu
On Wed, Jan 5, 2011 at 10:27 AM, Raj Mahapatra wrote:
> hi Jitendra,
>
> First, Define the name range of the countries as "Country"
> Second, Define the name range of