PC Review


Reply
Thread Tools Rate Thread

Re: Can I filter cell that have only 0-9 number in it?

 
 
Claus Busch
Guest
Posts: n/a
 
      13th Jul 2012
Hi,

Am Fri, 13 Jul 2012 03:48:45 +0000 schrieb lazyx:

> samsung
> samsung galaxy s2
> samsung galaxy
> samsung galaxy tab
> samsung galaxy nexus
> samsung galaxy note
> samsung infuse
> samsung galaxy tab 10.1
> samsung tv
> samsung galaxy s3
> samsung galaxy s
>
> I want to filter cells that have any number in it (0-9). So, the end
> result should shows only :


your products in column A from A2 on. Then make a helper column with the
formula:
=COUNT(FIND({1;2;3;4;5;6;7;8;9;0},A2))>0
and filter the helper column for TRUE


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
 
Reply With Quote
 
 
 
 
Claus Busch
Guest
Posts: n/a
 
      13th Jul 2012
Hi,

Am Fri, 13 Jul 2012 10:03:17 +0200 schrieb Claus Busch:

> your products in column A from A2 on. Then make a helper column with the
> formula:
> =COUNT(FIND({1;2;3;4;5;6;7;8;9;0},A2))>0


change the formula to:
=COUNT(FIND({1,2,3,4,5,6,7,8,9,0},A2))>0


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Field Filter vs. Number Field Filter on same table AndyC Microsoft Access External Data 0 19th Apr 2011 03:13 PM
For Excel 2007 copy visible cell only is only thru for few number Frank Situmorang Microsoft Excel Programming 1 6th Jun 2008 07:12 AM
Filter Filter Filter =?Utf-8?B?YW1zdXJpYQ==?= Microsoft Access Form Coding 5 28th Nov 2006 11:37 AM
count each cell that have a number and take that number and count. =?Utf-8?B?Vmljaw==?= Microsoft Excel Misc 3 19th May 2006 01:51 AM
Way to have VB code to filter on entries that have cell with today's date? StargateFan Microsoft Excel Programming 7 17th May 2005 01:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:03 PM.