needing a formula i think?
 

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?

needing a formula i think?
 

Yes if you give a bit (a lot ! ) more detail
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mirida" wrote in message
...
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?

needing a formula i think?
 

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!

"Bernard Liengme" wrote:

Yes if you give a bit (a lot ! ) more detail
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mirida" wrote in message
...
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?

needing a formula i think?
 

DataFilterAutofilterCustomShow rows where is less than the amount.


Gord Dibben MS Excel MVP

On Thu, 4 Dec 2008 12:53:01 -0800, Mirida
wrote:

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?

needing a formula i think?
 

Select all the data; use Data | Sort (do NOT use the AZ or ZA tools) and
tell Excel which
column(s) to use for sorting.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

"Bernard Liengme" wrote:

Yes if you give a bit (a lot ! ) more detail
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mirida" wrote in message
...
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?

needing a formula i think?
 

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.

"Gord Dibben" wrote:

DataFilterAutofilterCustomShow rows where is less than the amount.


Gord Dibben MS Excel MVP

On Thu, 4 Dec 2008 12:53:01 -0800, Mirida
wrote:

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?

needing a formula i think?
 

thank you very much. this informations will be very helpful for me. lets hope
i dont mess it up! lol

"Bernard Liengme" wrote:

Select all the data; use Data | Sort (do NOT use the AZ or ZA tools) and
tell Excel which
column(s) to use for sorting.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

"Bernard Liengme" wrote:

Yes if you give a bit (a lot ! ) more detail
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mirida" wrote in message
...
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?

needing a formula i think?
 

Send me the file (my email, not the newsgroup; just omit TRUENORTH.)
Tell me what the maximum value is to be.
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
Select all the data; use Data | Sort (do NOT use the AZ or ZA tools) and
tell Excel which
column(s) to use for sorting.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

"Bernard Liengme" wrote:

Yes if you give a bit (a lot ! ) more detail
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mirida" wrote in message
...
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?