software

I have a list of materials with:
material name, qty O/H, daily usage, weekly use, monthuse, yearuse.

the value of qty O/H will change color based on conditional formating,
which is just certain reorder points based on the appropriate usage #.
The color of a quot;to buyquot; material is red. At any time, i want a list in
another column of the materials and their qty O/H in order, without
spaces. Just point me in the right direction, i'll get the rest.--
beechum1
------------------------------------------------------------------------
beechum1's Profile: www.excelforum.com/member.php...oamp;userid=30489
View this thread: www.excelforum.com/showthread...hreadid=511452Hi
If I understand your request correctly, you want to list qty O/H in
ascending order, then in cell G2 enter
=IF(ISERROR(SMALL($B:$B,ROW(1:1))),quot;quot;,SMALL($B:$B, ROW(1:1)))
and copy down

--
Regards

Roger Govier

beechum1 gt; wrote
gt; I have a list of materials with:
gt; material name, qty O/H, daily usage, weekly use, monthuse, yearuse.
gt; the value of qty O/H will change color based on conditional formating,
gt; which is just certain reorder points based on the appropriate usage
gt; #. The color of a quot;to buyquot; material is red. At any time, i want a
gt; list in another column of the materials and their qty O/H in order,
gt; without spaces. Just point me in the right direction, i'll get the
gt; rest.
not in order of quantity, but in order that it's listed on the materials
list is fine. But in addition to the quantities (O/H) I also need the
corresponding material to be listed, so i know what i'm buying--
beechum1
------------------------------------------------------------------------
beechum1's Profile: www.excelforum.com/member.php...oamp;userid=30489
View this thread: www.excelforum.com/showthread...hreadid=511452