rday, May 28, 2011 7:24 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Need Matching excel formula
>
> Hi Excel Guru,
>
> i don't want to enter same mobile number. so i need matching or tracing
> formula.
>
> If I entered mobile number in a column
.com] *On Behalf Of *kannan excel
> *Sent:* Saturday, May 28, 2011 7:24 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need Matching excel formula
>
>
>
> Hi Excel Guru,
>
>
>
> i don't want to enter same mobile number. so i need matchi
PUT THIS FORMULA IN "C2"
=IF(COUNTA(B:B)mailto:excel-macros@googlegroups.com]
On Behalf Of kannan excel
Sent: Saturday, May 28, 2011 7:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Matching excel formula
Hi Excel Guru,
i don't want to enter same mo
Hi karan
Find attached sheet ..
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of kannan excel
Sent: Saturday, May 28, 2011 9:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Matching excel formula
Hi Excel Guru,
i
=IF(B1="","NO",B1)
On Sat, May 28, 2011 at 9:54 AM, kannan excel wrote:
> Hi Excel Guru,
>
> i don't want to enter same mobile number. so i need matching or tracing
> formula.
>
> If I entered mobile number in a column means, how do i know? i already
> entered this mobile number.
>
> pls find m
Please try this..
=IF(B1="","NO",B15)
On Sat, May 28, 2011 at 9:54 AM, kannan excel wrote:
> Hi Excel Guru,
>
> i don't want to enter same mobile number. so i need matching or tracing
> formula.
>
> If I entered mobile number in a column means, how do i know? i already
> entered this mobile nu
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of kannan excel
Sent: 28 May 2011 08:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Matching excel formula
Hi Excel Guru,
i don't want to enter same mobile number. so i
Hi Excel Guru,
i don't want to enter same mobile number. so i need matching or tracing
formula.
If I entered mobile number in a column means, how do i know? i already
entered this mobile number.
pls find my attachment.
regards
kannan V
onechennaiproperty.com
--
--