Use this formula to check same
=COUNTIF($B$2:$B$14,B2)
On May 28, 6:18 pm, "Omar" <omar27...@gmail.com> wrote:
> PUT THIS FORMULA IN "C2"
>
> =IF(COUNTA(B:B)<COUNTA(A:A);"NO";INDIRECT("B" & 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-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 means, how do i know? i already
> entered this mobile number.
>
> pls find my attachment.
>
> regards
>
> kannan V
>
> onechennaiproperty.com
>
> --
> --------------------------------------------------------------------------- -
> ------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below
> linkhttp://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
