Sorting

H

Himu

I have a column(say c1) of numbers. I want another column
(say c2) that will display only numbers that are greater
than 10. Is it possible to do this?..... Please HELP!!!
 
D

Don Guillett

Your subject line might give you a clue to try using
data>autofilter>custom
then you don't need an extra column
 
G

Guest

I would like another column to be generated with values
greater than 10. Can you please me advice me on how to do
that. Remeber I want the column to have the values greater
than 10.

Thankx!
 
B

Bob Phillips

Copy the heading of your column into another cell, put >10 in the cell below
that. Then Data>Filter>Advanced Filter, select the 'Copy To Another
Location' option, select your data for the 'List Range', select the 2 new
data cells for the 'Criteria', and select another column for the 'Copy To'
range, then OK.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
C

count

...and there's of course a simple formula version:
type this in E2, for example, then drag down with Fill Down handle to
populate as many rows as needed:
=If(D2<10,"",D2)
where Col D has all numbers and col E will have > 10 and blanks if not
HTH someone
Paul
 
Top