excel capabilities

G

Grouge

Hi Im newish to excel so maybe there is a really simple answer I a
overlooking or maybe it is not possible with excel but here is what
am trying to do.

I am trying to figure out a way scan numerical results in a column bu
return only results above a certain value. (so far a simple conditiona
formula) My issue is that my original column is extremely long and
have no interest in the amounts that are below my threshhold. I a
looking for a way that will only display the values above my threshhol
and not the ones below
 
R

RagDyeR

What *exactly* are you trying to accomplish with these "above threshold"
numbers?

Count how many there are:
=Countif(A:A,">100")

Add them together:
=Sumif(A:A,">100")

Mark their location in an adjoining column:
=If(A1>100,"X","")
And copy down the adjoining column as far as necessary.

Need more info if these examples are not what you want/need!
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
Hi Im newish to excel so maybe there is a really simple answer I am
overlooking or maybe it is not possible with excel but here is what I
am trying to do.

I am trying to figure out a way scan numerical results in a column but
return only results above a certain value. (so far a simple conditional
formula) My issue is that my original column is extremely long and i
have no interest in the amounts that are below my threshhold. I am
looking for a way that will only display the values above my threshhold
and not the ones below.
 
G

Grouge

ok more detail it is :)

My column of values is part of an inventory system that I use t
generate orders.

Right now I have the inventory on one worksheet and my order form o
the other. Im using the order form with a simple =IF(A>100, 0, A) .
THen i need to manually delete the hundreds of rows i get returned wit
zeros because all im interested in are the items below 100 (the ones
need to order). I am trying to find a way to return Only the value
below 100, completely ignoring the ones above in a column (no
returning hundreds of negative results that i need to sort through )

I hope that is clearer
 
A

Ardus Petus

You should have a look a Data>Filter>AutoFilter and Advanced Filter
This should fit your needs.

HTH
 
G

Grouge

that did it. I knew it was prolly something simple that I was missing.

Thx for the hel
 
Top