Use this formula to check same
=COUNTIF($B$2:$B$14,B2)
On May 28, 6:18 pm, "Omar" wrote:
> PUT THIS FORMULA IN "C2"
>
> =IF(COUNTA(B:B)
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of kannan excel
> Sent: Saturday, May 28, 2011 7:24 AM
> To: excel-macr
Dear kannan
find the attached solution.
--
*Thanks & Regards
Thamu*
On Sat, May 28, 2011 at 6:48 PM, Omar wrote:
> PUT THIS FORMULA IN "C2"
>
> =IF(COUNTA(B:B)
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *kannan excel
> *Sent:* Satu
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 mobile number. so
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 d
=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 need matc
