needing a formula i think?

  • Thread starter Thread starter Mirida
  • Start date Start date
M

Mirida

I'm not familiar with excel, but i have a list of 2400 items that i need to
narrow down to items less than a certain amount. someone help me?
 
alright, i have a list of over 2400 items that need to be narrowed down to
the ones less than a certain dollar amount...and then i would like to arrange
them in order from smallest to largest in price. at the moment they are
arranged in order by parcel number only and dollar amount all over the scale!
 
Data>Filter>Autofilter>Custom>Show rows where> is less than the amount.


Gord Dibben MS Excel MVP
 
Select all the data; use Data | Sort (do NOT use the A>Z or Z>A tools) and
tell Excel which
column(s) to use for sorting.
best wishes
 
thank you very much for the information. i wish there was a way for me to
just send it to someone and have them do it for me, lol. this should be
helpful.
 
thank you very much. this informations will be very helpful for me. lets hope
i dont mess it up! lol
 
Send me the file (my email, not the newsgroup; just omit TRUENORTH.)
Tell me what the maximum value is to be.
 
Back
Top