excel capabilities

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grouge - 17 Jul 2006 16:09 GMT

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

Reply to this Message

RagDyeR - 17 Jul 2006 16:29 GMT

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!

Signature

HTH,

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

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.

Signature

Grouge
------------------------------------------------------------------------
Grouge's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=36445
View this thread: http://www.excelforum.com/showthread.php?threadid=562093

Reply to this Message

Grouge - 17 Jul 2006 16:57 GMT

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

Reply to this Message

Ardus Petus - 17 Jul 2006 17:47 GMT

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

HTH
--
AP

> ok more detail it is :)
>
[quoted text clipped - 10 lines]
>
> I hope that is clearer.

Reply to this Message

Grouge - 17 Jul 2006 18:19 GMT

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

Thx for the hel

Reply to this Message