Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needing a formula | Excel Discussion (Misc queries) | |||
commission formula needing help | Excel Worksheet Functions | |||
NEEDING FORMULA Please | Excel Worksheet Functions | |||
Needing simple formula | Excel Worksheet Functions | |||
Needing to know how to use a "and" in a formula.... | Excel Worksheet Functions |