Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I link two columns for sorting? | Excel Discussion (Misc queries) | |||
Sorting Excel columns in several worksheets at once. | Excel Discussion (Misc queries) | |||
Macro sorting by 4 columns | Excel Discussion (Misc queries) | |||
Sorting columns with expressions | New Users to Excel | |||
sorting data across multiple columns | Excel Discussion (Misc queries) |