...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


Uzytkownik napisal w wiadomosci
...
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!
-----Original Message-----
Your subject line might give you a clue to try using
dataautofiltercustom
then you don't need an extra column

--
Don Guillett
SalesAid Software

"Himu" wrote in message
...
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!!!


.