Sorting
 

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

Sorting
 

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

Sorting
 

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


.

Sorting
 

Copy the heading of your column into another cell, put 10 in the cell below
that. Then DataFilterAdvanced 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)

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


.

Sorting
 

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


.