LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default Sorting by Two Columns

I designed a worksheet that has four columns. I need to sort the 400+ entries
in the worksheet by two columns. The first column (B), has entries of either
A-OK, A-UNDER, A-OVER. The second column (C) has entries of N-OK, N-UNDER,
N-OVER. The criteria for the sort is to show N-UNDER and A-UNDER. So I want
to be able to isolate the entries in the worksheet that have A-UNDER or
N-UNDER in columns B or C... also showing the values of A and D that
correspond to the row in which the *-UNDER appears. There are instances
where both A-UNDER and N-UNDER appear in which case I do not want duplicates
showing up. Could someone lead me in the right direction for accomplishing
such a task?

Thank you,
Luke Slotwinski
 
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
How do I link two columns for sorting? Danielle Madril Excel Discussion (Misc queries) 2 October 5th 06 03:29 PM
Sorting Excel columns in several worksheets at once. Dale60 Excel Discussion (Misc queries) 3 June 27th 06 11:34 PM
Macro sorting by 4 columns dcbpe Excel Discussion (Misc queries) 2 June 27th 06 02:52 PM
Sorting columns with expressions et New Users to Excel 2 October 10th 05 09:54 PM
sorting data across multiple columns Spiderman Excel Discussion (Misc queries) 2 October 6th 05 11:55 PM


All times are GMT +1. The time now is 04:49 AM.

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"