LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Excel Sort Function

Hi,

I am working with a spreadsheet of over 5000 lines at the moment. It is a
list of ink cartridges and there corresponding printers. Now we are looking
to sort/filter the list based on what cartridges they use. For example:

Printer Cart
abc 12
abc 13
def 12
def 14
ghi 12
ghi 14

so we then want to know which printers use cart 12 & 13. We do not want it
show any that may use the 12 & 14 or any other cobinations, just the two that
we have selected.

If this is possible, would it also be possible to use the same feature to
work on printers that take 54 cartridges etc?

Many thanks,

Jamie @ Fuzion
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort function for dates does not sort properly in Office 2007 Exc. Rosalie Excel Worksheet Functions 1 November 22nd 07 10:25 PM
Which sorting technique does Excel use in the sort function? DNALESOR Excel Discussion (Misc queries) 9 February 9th 07 10:26 PM
how do I turn off the auto sort function in excel Ollie Excel Discussion (Misc queries) 0 July 20th 06 04:44 PM
sort function to sort for bell curve Kuby Excel Discussion (Misc queries) 4 December 16th 05 06:51 PM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 08:37 PM


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"